topic Re: Sum column in pivot table in QlikView

Sum column in pivot table

Fri, 14 Dec 2012 18:01:52 GMT

hi,

i would like know how to get the total of one column at pivot table

i need one form different of sum(total field), i need some form work for column, for example sum(TOTAL Column Name) , its possible?

thanks..

Re: Sum column in pivot table

Gysbert_Wassenaar — Fri, 14 Dec 2012 18:49:42 GMT

See below for what sum(Sales) and sum(total Sales) do. There's also a sum(total <Product> Sales column that shows the total per product. The two dimensions Product and SalesPerson have the option Show Partial Sums enabled so the sub totals are shown in the pivot table.

Re: Sum column in pivot table

Sat, 15 Dec 2012 14:18:26 GMT

I managed to sum the column with the name, but i need now use the function aggr for group the products, how do it?

to follow example:

Bottom(TOTAL RangeSum(Above(TOTAL N2,0, NoOfRows(TOTAL))), 1, NoOfRows(TOTAL))

I need this, because N2 is a dinamic column....