1 Reply Latest reply on Jun 27, 2012 1:38 PM by Tracy Rodgers

    Top 3 set based on percentage difference?

      Hey.

       

      I'm trying to show the Top 3 items that had the biggest change compared to previous week.

       

      I know how to create a basic top 3 set based on weekly revenue. However, I don't manage to create a set based on the biggest percentage difference on revenue. Do I need a calculated field or can this be done with a formula in the set? Any guidance will be much appreciated.

       

      Joonas

        • 1. Re: Top 3 set based on percentage difference?
          Tracy Rodgers

          Hi Joonas,

           

          Depending on how the view is set up, creating a calculated field similar to the following and placing it on the filter shelf may get you the desired result:

           

          index()<=3

           

          Once placed on the filter shelf, right click and select Compute Using-->appropriate to how the table is set up (i.e. Table across) and select True.

           

          If this does not help, perhaps you can post a packaged workbook (twbx file)?

           

          -Tracy