One Pivot Table with two Dimension Conditions. Urgent

[renuka_sasikumar]

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

[#2]

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?

[sujeetsingh]

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

[renuka_sasikumar]

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.