Hello,
I am working on a project and the requirements demand three reports, with following columns:
1) Previous Month, Month 1, Month 2, ..., Month 6, First 6 Months Total
2) Previous Quarter, Quarter 1, Quarter 2, ..., Quarter 6, Tot First 2 Quarters
I am used to using key figures as the columns and characteristics in the Dimension as the rows. Do I need to create: Previous Month, Month 1, Month 2, ..., Month 6, First 6 Months Total, Previous Quarter, Quarter 1, Quarter 2, ..., Quarter 6, Tot First 2 Quarters; as key figures?
If not, I will appreciate any suggestions.
Or, is there a way to achieve this with the Time Dimension?
Thanks in advance.