4 Replies Latest reply on Oct 2, 2017 9:29 AM by Hari Ankem

    Aggregated Total without dimension

    Sumit Jain

      Hi Folks,

       

      i have the following data set

       

      Fiscal Quarter
      Revenue
      FY17'Q34500
      FY17'Q47500
      FY18'Q115000
      FY18'Q290000
      FY18'Q3

       

      I want aggregated total at fiscal quarter level where when i select FY18'Q3 in filters, all the total from the previous quarters get added up.and show 117,000

      I tried doing this with Total() and Running_SUM() funciton.

      However, in my sheet, i cannot show Fiscal quarter as a dimension and Total () and Running_SUM() functions only works when there is a dimension against them in the sheet.

       

      Can you please help getting a solution on this ?

      Let me know if you need further information.