Change Totals function in Pivot

[chriys1337]

Hi,

I am looking for the option to change the "Totals function" from "auto" to "sum" in a Pivot Table. In a Straight Table I found this setting, but the Pivot is missing it?

Background is, that I use a complex summing logic, with ifs in the Pivot and the "auto" functions sums the Grand Total incorrect. I transferred a copy of the pivot as straight table and there changed the totals function to explicitly "sum" and the total is correct. Can I do same in a Pivot?

Thanks for your help.

[beck_bakytbek]

Hi Chriys,

in the case of "Pivot table" you can solve this issue by using of Aggregation-function

[chriys1337]

Hello Beck,

you mean, this option is in the Pivot missing?

But I could use sum(aggr(x), all dims) to get same results?

[beck_bakytbek]

yes, you can do this