Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have developed a report in which i have used a calculated dimension to make columns for the expression by transposing it,
year_cd & '-' & month_cd, this calculated dimension has been created. its value is like this py-jan,py-feb...
.....py-dec.
Now the data is refreshed after every month, and the reports are based on the data of the 12 months.
i need to show this dimension in a pattern which changes every month, its like
for jan, it must start with py-jan,py-feb......
for feb,it must start with py-feb,py-mar........py-jan.
and so on till december.
How can i achieve that????