1 Reply Latest reply on Apr 4, 2016 4:41 PM by Patrick Van Der Hyde

    Grand Totals for each Dimension

    ugo nnodu

      I am trying to get the grand totals to display in a new grand total column when the dimension is selected from a filter. for instance i have attached a spreadsheet that has region, state, measure 1 and measure 2. Measure 2 is the grand total of all the dimensions. I want to be able to select dimension( state ID 1,2) and be able to get the grand totals for each dimension displayed on measure 2 tab.