7 Replies Latest reply: Jul 25, 2013 1:49 PM by ILARIA CREMONESI RSS

    Custom total of rows in pivot table

      Hello everyone,

       

      I am trying to build a pivot table with a custom total of rows, i.e. not the total of all the rows but with the total of some of the rows of the table based on the value of an expression.

       

      See the image attached:

       

      I want to get a row with the sum of the rows where the value computed is not null

       

      For example 

      the total of  column Variante = 24 is 176.523

      the total of  column Variante = 23 is 177.919

      the total of  column Variante = 22 is 181.183

       

      What I would like:

      the total of  column Variante = 24 to be 175.952 ( i.e. the total of 176.523 minus 570 because the item M10414N90 is not shared by Variante 24, 23 and 22)

      the total of  column Variante = 23 to be 177.919

      the total of  column Variante = 22 to be 181.183

       

       

      Thank you!