Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Identify 2 different rows under the same table

Hi All,   I have the below table and use the slicer select report date. When the user selected 14-Feb to 28-Feb in the slicer. I want to compare all records from 14-Feb and 28-Feb. Identify which o...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks all,

     

    Let me take some time to apply the above solution and let you know the outcome. 


    Many thanks

    Clement

     

Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi Clement:

One way to do this is to have an extra slicer just for report date. You'll see the report date slicer on the left and then an overall date slicer on the right. For the report dates I manually entered the three dates in (Enter Data) but you can also paste  excel data there if you'd like instead.If you only want to group by the 3 report dates you may not need the All Date Slicer. I am attachttps://drive.google.com/file/d/12Epr69lOgr33NTPZDYg4XRubqqeTjFQW/view?usp=sharing hing a link. 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi

 

Thanks for your response. However, I expect the selection will be 2 report dates, the measure needs to compare both reports dates data to see how many orders on the first report date are not available on the 2nd report date, how many orders on the 2nd report date but are not available in the first report date, how many orders are both existing in first and 2nd report dates.

 

Thanks

Clement