Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How can we hide dimensions in pivot table?
Thanks,
Hi,
PFA
hope this helps you
Thanks,
Chanty
Hi,
You can hide a dimension conditionally by using the
Chart Properties-> Dimension-> Enable Conditional option.
Check this link
Regards,
Jagan.
Hi tyagish,
If get the exact information make it as correct answer.bcz it wil helps you while finding anyone on dis.
Thanks,
Chanty
Hi Jagan Mohan,
Thanks for quick reply But Adhoc Reporting.qvw is working for Straight table.
And I want to hide dimensions in pivot table.
Please help me.
Thanks,
Hi Suri qv,
Thanks for quick reply,
Can we have any solution other then Macros?
Any statement in Enable condition or layout condition etc..
If yes please help me.
Thanks,
hi,
PFA
Hi Tya,
You can hide dimension using object properties. Like this way
Chart - > Properties -> Dimension -> enable condition option -> write code which dimension you need hide.
Hope it will help you.
Ramya.
HI,
I have 6 tables/ Pivot Charts on my dashboard, I am sending all pivot charts together into excel by using macro.
Now on excel sheet, i want to show dimensions only once, i.e. only one chart(1st chart) should shows its dimensions, rest show only expressions.
Thanks,