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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table

Hi ,

i have a pivot table ;

A Jan Feb Mar Apr Total

XX 1 1 1 1 4

YY 1 2 1 3 7

Can i add a column to pivot table near total column ;

A Jan Feb Mar Apr Total Avg

XX 1 1 1 1 4 1

YY 1 2 1 3 7 1,79

how can i add it...

thanks

1 Reply
Not applicable
Author

I don't think it's possible without some extra work. It can be done if you make every column a separate expression. The column expressions and labels can still be dynamic depending on which months you want to show, but you won't be able to use the partial sum, so Total will need to be an expression as well.

If you want to stray from the basic pivot setup, it can get really messy, but I've been able to come up with some nice customized pivots after a little work.