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

    Top 3 set based on percentage difference?



      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.



        • 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:




          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)?