topic Pivot Table in QlikView

Pivot Table

Mon, 21 Dec 2009 21:32:45 GMT

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

Pivot Table

Mon, 21 Dec 2009 22:15:35 GMT

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.