If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Calculations for relative time

Started by Cognosnewbie26, 02 Sep 2020 12:24:50 AM

Previous topic - Next topic

Cognosnewbie26

Hi,
My time dimension looks like below:
Year
Quarter
Month
Date
I want to create a calculation for Prior Time ( it can be prior year, quarter, month or same date of previous year)
I was wondering if I can create a calculation in such a way that it is able to gauge  if it is a year, quarter, month or date is pulled for the current year
For e.g
                           Month     PYMonth
Account No

In the above case if I pull the 'Month' then it should be able to calculate the amount for the PYMonth