Forum Discussion

5 Replies

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion

    create a separate date field that has joins with these two and create a single slicer. Why do you need 2 slicers if they're supposed to show the same values?

    • Anonymous's avatar
      Anonymous
      Not applicable

      1 looks at the date something was invoiced the other looks at MRR date looking at each month, i have tried to do the date table then relationship but because i already have relationships between the other tables am unable to do this

    • Anonymous's avatar
      Anonymous
      Not applicable

      i need to create the relationship between Rev by Territory to Date and Query 1 to date but obviously unable to do this?

      • Stachu's avatar
        Stachu
        Icon for Community Champion rankCommunity Champion

        assuming the existing joins are on the Order ID you should be able to do this when you switch the order of existing joins to single direction rathen than both