How to add an expression into a pivot table without being divided on columns?

Wed, 11 Sep 2013 15:30:51 GMT

Hi,

I have a pivot table with details for two dimensions: Material in row and Month in column. I'd like to add a new expression in the table independently of the existing one, but not to be split into month detail (see the attachment - Col2). How can I do that without be constrained to add the expression split into months?

Thank you in advance,

Cristina

Re: How to add an expression into a pivot table without being divided on columns?

Gysbert_Wassenaar — Wed, 11 Sep 2013 16:30:34 GMT

You'll have to add the expression as a calculated dimension. Perhaps something like =aggr(sum(ind1/(ind2-ind3)),Material)

topic How to add an expression into a pivot table without being divided on columns? in QlikView

How to add an expression into a pivot table without being divided on columns?

Re: How to add an expression into a pivot table without being divided on columns?