Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 dimension list and one pivot table.
Dimension 1 Dimension 2
All Division
Business Analysis Sales Group
Manpower Sales Office
Leadership Gap
So by default my pivot table will be shown on Dimension 1 all.
And even I want to show when selected Division its should show Division wise.
That means one Pivot Table with two Dimension Conditions.
Is it Possible?
Thanks & Regards,
Renuka
Not sure I understand your end requirement, can you post up an example of each? Sounds like it should be doable with conditional dimensions though yes.
Dimension 1 for instance sounds like it's actually 4 dimensions? Is this a group?
Yes it is possible
You can make the Dimension conditionally enabled.
So let a Button is set to make variable vDim =1.
Now you can set at second dimension condition as
=if(vDim=1,1,0)
Try the logic
For Dimension 1
All is nothing but three chart of Business Analysis, Manpower, & Leadership Gap.
So wen i select Business A it will show only Business same for the rest.
But I want to add one more condition with this that Wen any one selected from Dimension 2 den its should change accordingly.