Disabling columns in pivot tables

[#1]

Hi community,

i have a pivot table with several different columns. Is there any possibility to disable and also re-enable single columns with a chart object? I'm aware i can disable and enable those colums in the pivot table properties like shown in the attached file.

So if possible, does it require advanced developing skills? All it needs to do is enabling and disabling columns like you can do it in the properties, but with a chart object.

Thanks for your help,

Dominic

[Anonymous]

Hi Dominic,

Maybe you could hide/show columns enabling Conditional and using variables. You could create an object that toggle the variable between 0 and 1 to show/hide your column.

Hope it helps on what you need.

-- Karla

[trdandamudi]

Yes, you can do it. Use the conditional box with variable,

[#4]

Thank you, i did it