Different calculations for different views in a pivot table

Anonymous — Tue, 04 Sep 2018 10:17:58 GMT

Hi,

I am wondering if its possible to show different calculations for different view in a pivot table.

To make myself clear, I have the below table where I have Region, Country, Entity & Value.

The NA in Booking entity is the country level data, where as rest (B1, B2) entity level data.

What I am trying to do, that when showing in a pivot table if I expand the country it should show B1, B2, NA. Its easy and it can be done.

But if I collapse the county node, it only should show the value for NA, rather than summing up B1+B2+NA, like its showing below, which I don't want.

Ideally it should be showing 10, not 19.

Please help.

stalwar1‌ any help buddy?

Re: Different calculations for different views in a pivot table

andrey_krylov — Tue, 04 Sep 2018 10:34:04 GMT

Hi, Anurag. Dimetionality() will help you. See attached