Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi, Anurag. Dimetionality() will help you. See attached
Hi, Anurag. Dimetionality() will help you. See attached