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 All,

 

If I want to calculate the total qty of each category (first date only/second date only/both dates), it is possible to use calculate sum qty filter each category? I tried but seems syntex error. Also, from both dates category, I also want to identify how many POs are with different "date" column value and how many day different.

 

Thanks

Clement  

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

I don't see category in your sample data. Can you please advise how would be thevexpected results based on the given sample data?