Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My pivot table appear a date 2030 Dec, which is wrong date.. May i know it is possible make it disappear ?
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
u want to hide column? or data? is it dimension?
Use a calculated dimension instead of YearMonth field as dimension -> If(YearMonth <= Today(), YearMonth)
if its dimension
=if(Dim1=Dim2, null(),'')
supress nul values and hide dimension in presentation tab
may be in date column have data
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
Hi
Try like this
Calculated Dimension
=If(Year <= Year(Today()), YearMonth)
try this expression
If(YearMonth <= Today(), YearMonth)
Hi All
Thank you very much for all your sharing , it work fine.
Paul
Hi All
Now i make my table more flexible . by insert diamension :-
=$(ColumnDim_p)
May i know how to remove 2030 Dec ?
Paul