6 Replies Latest reply on Aug 11, 2017 3:16 PM by Shinichiro Murakami

    Column level calculation

    Vaibhav Gupta

      Hi People,


      Want your help in solving the below problem.

       

       

      My data set is something like this:

      GPID

      Week No

      Level

      Budget

      1

      30

      High

      1784

      2

      30

      High

      3871

      3

      30

      Low

      3477

      4

      30

      Medium

      1733

      1

      31

      Low

      3700

      2

      31

      Low

      3780

      3

      31

      Low

      3609

      4

      31

      Medium

      2309

       

      Need to create a report to display :

       

      How many GPIDs have moved from level High to Low in two different week and probably if i could highlight the accounts too.

       

      I'm not sure how we implement column level calculation.

       

      Please Help.!!

       

      And Thank you all in advance.