11 Replies Latest reply on Jun 9, 2016 6:29 AM by Steve Taylor

    How to increase the value of your top N by x%

    Sam Wright



      I have data on products which fit into categories, and a worksheet than displays them by category and descending sales. What I want to achieve is to answer "if I increase sales on my top N products within each category by X%, what will be the extra benefit?"


      Now its easy enough to do the X% bit as its just a parameter but how can I work out the top N in a calculated field so that it goes


      if [product in top N for sales within category] then [sales]*(1+[X percentage increase])

      else [sales]



      How do i do thefirst bit? I've attached a basic version of what I am trying to achieve, using the top two but you will notice I've had to hard-code the top two within each category- not ideal.


      Any help greatly appreciated,