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

 

Point 1 your understanding is correct.

Point 2 in fact I only have 1 table that same as sample date. I did not create any other table for report date or other data. Is it still possible to compare same POs under selected report date to determine how many PO and qty with same "date" and different "date". If they are with different dates, also found out PO count and qty per day different. e.g.

 

Same date PO = 3 POs and 300 qty (PO7-PO9)

Diff date PO = 3 POs and 300 qty (PO4-PO6)

2 days diff = 3 POs and 300 qty (PO4-PO6) (in case we have other days diff like, will also list out each days diff PO and qty).

 

or just simply list out no of days diff PO and qty, then I can assume day diff is 0 meaning same date.

 

Thanks

Clement

 

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 

Ok I think this is almost the same as my initial understanding. But how are you planning to display the results? In card visuals?