Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average instead of sum in pivot table

Hi!

I've created a pivot table with som expressions which are represented as columns. Is it possible to show an avarage at the bottom of a columns instead of a partial sum?

10 Replies
svenkita
Creator II
Creator II

Dimensionality() indicates the level of subtotals in pivot tables. For example,

if you have a pivot table with dimensions A, B, C  and D,

subtotals for A will have a dimensionality of 1                            

subtotals for B will have a dimensionality of 2

subtotals for C will have a dimensionality of 3

subtotals for D will have a dimensionality of 4

How to use - Dimensionality()