Re: Pivot Table: how to show expression only in total
I taked a look at your example and it's useful.
See the pivot table below:
where i'm using dimensions and expressions with conditional option enabled.
I need to add a column as "Total divided by the number of dimension values" that in this case is 7 (Esercizio 2009, Esercizio 2010, Esercizio 2011, Esercizio 2012, Esercizio 2003, Esercizio 2014, Esercizio 2015).
The new column should works as below for "CT01 ENERGIA" row:
Totale esercizio Media esercizio
29.465.482,92 4.209.354,70 (that is 29.465.482,92 / 7)