Column hide in pivot table

[vardhancse]

Hi,

Have a requirement is that I want to hide some columns in the pivot table is that possible./

[#2]

Hi Sasi,

You can use Conditional Enabling.

Properties ---> Dimensions  -)--->select Used Dimensions Which one you need to hide ---> Setting for Selection Dimension --> Check conditional Enable below you can write --- Condition...

Ramya.

[vardhancse]

Used condition:

=if(Year=2012,RGB(255,255,255),if(sum(Sales)>after(sum(Sales)) or sum(Sales)>before(sum(Sales)),Red(),Green()))

in the YOY expression.

Result is:

 

Can any one please let me know how to merge 2012 ans 2013 under YOY, or

completely remove 2012 under YOY or

Merge 2012 and 2013

gwassenaar‌ can please help me out.

[jagan]

Hi,

PFA file for solution.

Regards,

jagan.

[hariprasadqv]

-Enable expression on condition.

[Gysbert_Wassenaar]

Use a straight table instead of a pivot table. See attached example.