Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.