How to Hide this column in pivot table

[Anonymous]

HI

I just want to hide a column (expression ) where the values are null  and i'm uisng version  QV 10

please see the attached file

[Anonymous]

i want ot hide the YE 2012 Statutory column where all the values are nulls

[Gysbert_Wassenaar]

I'm afraid thats not possible. The expressions will be shown for each value of COST TYPE. Even if expression returns only nulls for all rows. You could try combining your two expressions into one.

if(COST_TYPE='YE 2012',

     Sum(ELEMENT_ITEM_COST)

     Sum( if(COST_TYPE like 'Frozen',ELEMENT_ITEM_COST, null())) - Sum( if(COST_SUB_ELEMENT like 'MTP',ELEMENT_ITEM_COST, Null()))

)

[Anonymous]

you are right .. even  i felt the same .....but at end user point that doesn't make any sense to show a null values column...

Anyway  just want to give it a try for any workaround suggestion...

Thanks for your reply