Date Range Prompt for Dashboard using Power cube as a source

[arifj1981]

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!