Hi All,
I have scenario display only last 24 months data by monthly( we are restricting 24 months data backed), I have per day data in column.
They want see first current month, followed by physical month name.
for example.
Current month(September 2017)
August 2017
July 2017
June 2017
.
.
.
.
.
july 2016
.
.
.July 2015.
Thanks
I went back and figured it out
Create a calculation
if datetrunc('month',[Order Date]) = DATETRUNC('month',today())
then 'Current Month' else DATEname('month',([Order Date])) + " " + DATEname('year',([Order Date]))end
Place it on the row shelf next to the MY date pill then hide the MY dates by de selecting Show Header
and you end up with this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
