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

 

My first chart will be list out qty of slicer selected first and last date

 

Then I want to have a card or table to indicate both report dates how many PO and qty only available at the first report date, how many PO and qty only available at the last report date. How many PO and qty available at both report dates.

 

Then understand from PO existing in both report dates. How many PO and qty with same "date" and different "date". Then may a bar chart show diff day (-/+) at x-axis and PO/Qty at y-axis.

 

Thanks

Clement