Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

AVG in Pivot Table when dimension is collapsed

Hi,

i have this problem: In my pivot table there are 5 dimension (year,quarter,month and other 2 dimentions).

there are more expressions in my pivot table.

I want to do a average function instead of subtotals ,on year dimension, when the quarter and month dimentions are collapsed.

anyone have any idea?

Thanks,

Luigi

0 Replies