Possible hide column with date 2030 Dec ?

[paulyeo11]

Hi All

My pivot table appear a date 2030 Dec, which is wrong date.. May i know it is possible make it disappear ? 

[Peter_Cammaert]

Either in your Calculated Dimension replace YearMonth with your new dimension specification $(ColumnDim_p), or - as the previous may lead to unexpected expansions (you don't know what's inside variable ColumnDim_p) - throw the 03 DEC value out in your expression, as shown here: Re: Possible hide column with date 2030 Dec ?

[sunny_talwar]

This still seems to work -> =If($(ColumnDim_p) <= Today(), $(ColumnDim_p))

[paulyeo11]

Hi Sunny

Thank you , but when i change the Year , 2030 still appear.

Paul

[paulyeo11]

Hi Peter

Your expression work fine . Thank you very much.

Paul

[paulyeo11]

Hi Sunny

Peter Expression work fine. He try to do the filter those date which is higher then today.

Paul