1 Reply Latest reply on Sep 28, 2017 10:33 AM by Hari Ankem

    Viewing Measure as Dimension

    kitty.lau

      Hi,

      I have a dataset which shows revenue of 'Accounts' over a time period.  I am wanting to see what is the breakdown of revenue for each month for 'Accounts' as per below:

      Existing MRR (total amount from December of the prior year}

      Growth

      New MRR

      Credit Note

      Disabled

      Cancelled

       

      I have created table (attached) with the dimensions in 'Transaction Type for Month' showing everything but 'Growth' and 'Beginning MRR (as at December of prior year).  Growth and Beginning MRR (as at December of prior year) is calculated under 'Measures' and I have put it as a 'Tooltip'.  Is there a way I could include 'Beginning MRR' (as at December of prior year) and 'Growth' as dimensions in 'Transaction Type for Month'? The Dimensions in 'Transaction Type for Month' are 'IF' formulas and so I'm at a loss how to incorporate the 'Growth' and 'Beginning MRR' which are aggregate calculations in the same Dimension.

       

      Thanks!