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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi tamerj1

 

Thanks for your help and provide feedback even via the phone. Really appreciate!

 

The outcome looks good. When I select different start and end report date, I found the outcome is not quite correct. The 3rd table cannot identify the correct category.

 

Thanks

Clement

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Anonymous 
    I have updated the code in my previous reply. You can download again with the error corrected.
    Have a great day!

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 

    Just checked the file and seems working fine with all selections. I have no idea why it is showing wrong results with you. Please try to redownload as per the new download link https://www.dropbox.com/t/YzOxcv7gVGAJILJ3