Different calculations for different views in a pivot table

[Anonymous]

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.

Region	Country	BookingEntiry	Value
R1	C1	B1	4
R1	C1	B2	5
R1	C1	NA	10

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?

[andrey_krylov · Accepted solution]

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