12 Replies Latest reply on Jun 14, 2018 10:48 AM by dinesh punnam

    Grand Total of a Column (Calculated Field)

    Jerry Li

      I want to show the total of a column (calculated field) based on other columns.

       

      However, the grand total option does not sum the column value, it shows a calculation based on the sum of other two columns which used in the calculated field:

       

      Original Measures:  Mkt Value, Price

      Calculated Field:  Weight of Mkt Value, Composite (Price * Mkt Weight)

      Dimension: Tix

       

      I want to show the sum of Composite (price*weight) for all Tix (1~6), it doesn't need to be showed in a table format, any other chart is ok.

       

      Attached a sample workbook.

      Any help is appreciated!