2 Replies Latest reply on Jun 1, 2012 12:34 AM by Laurent Moffroid

    What would the 2009 entity sales be if we apply its 2000 share of the total to the 2009 total?

    Laurent Moffroid

      Hi,

       

      I am stuck with the following issues:

      a) Say I have 10 entities over 10 years, from 2000 to 2009incl

      Say years are in columns and entities are in lines and I look at their sales

       

      I have created a calculated field to give the % of each entity sales in the total for each year, so bottom of the column is 100%

      I want to freeze the first year proportion of the total and apply that to each following year total in order to get for each entity for each year a "simulated sales" number that is 'what would your sales be had you stick to your year 2000 % of the total?'

       

      Then of course I would like to see the difference between the actual sales and the simulated sales

       

      b) Coming back to these 10 years, let us say i have many entities and they can have from 1 to 10 datasets

      I would like to create some bins like

      1 dataset

      2 datasets etc

      and then return the number of entities that have 1 dataset, 2 datasets etc.

       

      Thank you very much for your help!