Forum Discussion

navinkb9's avatar
navinkb9
Frequent Visitor
3 years ago

Last Period

Team,

I have a requirment to define the default values as Last Period always.  In the given scenario I am in P07 but I would want the slicer to have P06 selected by default. Same way, when I am running report for P08, it should select P07 by default. If it was a date field we can do this easily. Now the question here is that, the Year Period Column is in Text Format and I am not able to find a way on how to acheive this.

 

 

 Just FYI.. Each period has defined number of days for example see below 

 

2 Replies