0 Replies Latest reply on Dec 5, 2018 11:43 AM by alexander.turner.0

    Calculation within dimension

    alexander.turner.0

      Hi all,

       

      I have a dimension called "Aba_Code" that includes various Codes from 30 through 90.

       

      If I drag "Aba_Code" in rows and Sum[sales] I get the following:

       

      AbaCode, Sales

      30, 1500

      31, 2500

      ....

      90, 3000

       

      I want to create various new rows with a number of different calculations such as:

      31-30 = (2500 -1500) = 1000 or 90 - 31, etc.

       

      Then the above would look like:                 

      30, 1500

      31, 2500

      31-30, 1000

      ....

      90, 3000

      90-31, 500

       

      Is this possible?

       

      thanks,

      Alex