7 Replies Latest reply: Jun 22, 2013 10:39 AM by Stephen Redmond RSS

    Aggregation & Set analysis queries. Applying past performance to future.

    Raghav Kumar

      Hi

      I am trying to use detailed data of past performance and make projections for future.

       

      This is my past sale trend. For a given state, district and product combination, there is the actual volume sold.

      Past sale trend
      StateDistrictProductVolume_sold
      S1D1P1100
      S1D1P2200
      S1D2P2300
      S2D3P3400

       

      Now, at a macro level, I have the projection or target volume to be sold at a state level.

       

      Plan for sale future
      StateVolume_plan
      S1700
      S2500

       

      I want to do these 2 tables below using pivot table.

       

      Plan break up Districtwise and Productwise
      StateDistrictVolume_plan
      S1D1
      S1D2
      S2D3

       

      StateDistrictProductVolume_plan
      S1D1P1
      S1D1P2
      S1D2P2
      S2D3P3

       

      I am not clear about the use of TOTAL or other Set analysis functions.

      Any help would be extremely useful.

       

       

      Thanks in advance

      ragha