Discussion Board for collaboration related to QlikView App Development.
Hi have this PIVOT table with two expression: Clienti and CONSUMO GAS
correctly it show me the Total for my Dimension (Partial Total), but i not want to show the TOTAL about CLIENTI in the end (Grand Total), is possible?
that gives a clearer picture of what you require.
the misunderstanding was that Clienti is an expression and not a dimension. also Pivot tables dont have grand totals it has partial sums.
so your requirement is to disable partial sum of one of the expressions and not partial sum of the dimension. unfortunately, pivot tables will show partial sums of all expressions and you can only control what dimensions have or dont have partial sums