1 Reply Latest reply on Apr 11, 2017 12:09 PM by Kaz Shakir

    sum of column

    kamran munib

      I have 3 columns first 2 are dimensions and the 3rd one is measure. I want to add a row which shows total for 2nd column dimension

      Example

       

      Column1    Column2      Column3        New column2

      N                  dev            1                         4( adding dev)

      A                   qa             2                         2

      O                 dev             3

        • 1. Re: sum of column
          Kaz Shakir

          Kamran,

          You should be able to accomplish that with a simple Level Of Detail (LOD) calculated filed.  Try creating a calculated field that looks like this:

           

          New column2

          {FIXED [Column 2]: SUM([Column 3])}

           

          Hope that's helpful.  Please let us know if that worked.

          Kaz.