5 Replies Latest reply: Feb 16, 2018 2:56 PM by Jorn Vangoidtsenhoven RSS

    Data Handling -- Calculation condition

    Jorn Vangoidtsenhoven

      I have a table that shows county, sum(sales), sum(sales 6 months ago), sum(difference in sales).

       

      The table shows the county and how the all-time sales through today differ from the all-time sales through (today - 6 months).

       

      The goal is to show the biggest gainers and losers of the past 6 months.

       

      I can use "fixed number -> top 5" to show the 5 biggest gainers.

       

      How do I show the counties that lost the most, starting from the counties that were the biggest 6 months ago?  I tried using "top 5" after filtering the table to show counties with no difference in sales (of which there are plenty), but I can't get the "Data handling -> calculation condition" to work.

       

      Thanks!