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.

       

      Thanks

      Anu