Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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.
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....