Hi Experts,
I have a situtation where i need to build a pivot table where the expansion is upto level 3.
In the example below OMAN location has two types RESIN FG and SHEET FG and futher expanded to Material Grade values
But this expansion is only applicable for OMAN location value. Others should show the value at level 2
i see it automaticlly expanded for all values even though there is no dimension value for level 3( Example CINCI in below screenshot )
i tried unchecking avoid NULL values for level 3 dimension but problem is whole CINCI dimension value disappears
How to avoid this?