Was there any answer to this? I am trying exactly the same in my pivot table but can't find the solution.
I have used SecondaryDimensionality but that hides everything. I want to display only the total column.
Hi Stefa,swuehl would you know the workaround here? exactly same example as Massimiliano above table.
I hope the attached example answers your question.
Color del texto.qvw 187.0 K
I taked a look at your example and it's useful.
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)
How is possibile to achieve it ?
Many thanks in advance.