4 Replies Latest reply: May 2, 2013 9:00 PM by Avik Mukherjee RSS

    Dynamically Change Dimension and Grouping Expression in Cumulative calculation

      Hi All

       

      I need urgent help on this please:

      I have data like below,

       

      PeriodClassGroupNo of Intake
      Jan1VM5
      Jan2VM2
      Jan3ST3
      Jan4ST3
      Feb1VM2
      Feb2VM2
      Feb3ST1
      Feb4ST5
      Mar1VM3
      Mar2VM1
      Mar3ST1
      Mar4ST3
      Apr1DC2
      Apr2DC2
      Apr3DC1
      Apr4LP2
      Apr5LP3

       

      Now, In Jan Yearly Total Intake by Group Report Should Show,

       

      GroupYTD Intake
      VM7
      ST6

       

      Because, VM total = Class 1 + Class 2 and ST Total = Class 3 + Class 4

       

      Similarly,

       

      Feb Report will be :

       

      GroupYTD Intake
      VM11
      ST12

       

      Mar Report will be:

       

      GroupYTD Intake
      VM15
      ST16

       

      But interesting will be the report of Apr, where re grouping caused, Class 1, 2 & 3 to be under DC and Class 4 under LP and a new class introduced which is class 5 and that also is under LP.

       

      Now for Apr report, YTD Total for DC will be = YTD total of Class 1 + YTD Total of Class 2 + YTD Total of Class 3; Similarly LP Total = YTD Total of Class 4 + YTD Total of Class 5;

       

      And the report should be as:

       

      GroupYTD Intake
      DC25
      LP14

       

       

      I've no Clue how to display this. Would you kindly help?