2 Replies Latest reply on Oct 10, 2016 12:02 AM by Shiva Krishna Palakonda

    How to create a category(KPI or filter) by comparing last two values

    Anu Rekha

      Hi All


      Hope you all great.


      How can I create a classification by comparing the last two values of dates in the  dataset.

      Say Today's Sales and Yesterdays Sales, If difference is positive create a category such as "Good" else "Bad".


      I have  a crosstab where I have all the dates and sales and base on a parameter I want to display Good sales and Bad Sales based on above Calc.


      When I put this as a filter of the above calculation all the previous dates disappear, I am only getting the last date only, although result is right.


      Please let me know if you have faced this situation before and had a solution.