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 ? 

[Chanty4u]

u want to hide column? or    data?   is it dimension?

[sunny_talwar]

Use a calculated dimension instead of YearMonth field as dimension -> If(YearMonth <= Today(), YearMonth)

[Chanty4u]

if its dimension

=if(Dim1=Dim2, null(),'')

supress nul values and hide dimension in  presentation tab

[Anonymous]

may be in date column have data

[Peter_Cammaert · Accepted solution]

Or in your script, throw out all future years (those you do not want to see) from your MasterCalendar.

Or change your pivot table expression into:

money(

(Sum({<year = {"<=$(=Year(Today()))"},

       $(ColumnDim51)={$(ColumnDim51)}>} Amount)/$(Columndim89)/1000)

, $(vMoneyFormatK))

This will eliminate all data from the next year and later. Change to whatever cut-off year you like.

Peter

[MayilVahanan]

Hi

Try like this

Calculated Dimension

=If(Year <= Year(Today()), YearMonth)

[Anonymous]

try this expression

If(YearMonth <= Today(), YearMonth)

[paulyeo11]

Hi All

Thank you very much for all your sharing , it work fine.

Paul

[paulyeo11]

Hi All

Now i make my table more flexible . by insert diamension :-

=$(ColumnDim_p)

May i know how to remove 2030 Dec ?

Paul