Hi Team,
We are using Cognos Analytics 11.1 we have a requirement where in we have 2 columns one is current year(CYTD,CQTD,CMTD,CWTD/Year on Year,Month on Month,Week on Week)and the other is previous year(PYTD,PQTD,PMTD,PWTD,PYear on Year,PMonth on Month,PWeek on Week).These 2 columns should be calculated for a selected fromdate to todate. (The actual scenario is to provide a calendar prompt for passing date range). The Source for this requirement would be a Power Cube.
Any suggestions/solutions will be of great help.
Thank You in advance.
Cheers!