Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table. The column is Weekly Date. Currently it is showing past weeks , current week and future weeks.
They want it to show future week.
E.g the values currently are 3/19, 3.26, 4/2, 4/9, 4/16
the want to see only 4/9, 4/16 and beyond
How do I do that?
try this
create week(Date) as Week_no
and variable : vCWeek = =(week(today()))
then use in set analysis below.
sum({$<,Week_No= {'>=$(vCWeek) '}>}Sales)
try this
create week(Date) as Week_no
and variable : vCWeek = =(week(today()))
then use in set analysis below.
sum({$<,Week_No= {'>=$(vCWeek) '}>}Sales)
Thanks.
1. Its not a set analysis measure. Its a column in the pivot table. How to do there?
2. When using >= , don't we surround it by " ". You have surrounded it by ' '.
Simply add calculated dimension: IF( WeekNumber >= Max(WeekNumber), WeekNumber )
Thanks . Your solutions helped. Depending upon the need one can choose set analysis or calculated dimensions.
I resolved this way -
if( [Weekly_Date] >= weekend(today(),0,0), [Weekly_Date])
My first week of the day was set to 5 and the weekly dates were displaying the saturday dates.