Cognos issue

[laxmanrao83]

Hi all,

I have requirement like

i have calander year month(2010-05) Prompt.if i select thid year month, report need to display previous 12 months data(from 2009-05 to  2010-05).

Could please help us on this requirement asap

[leahmarie]

Is this relational or dimensional? If it is relational I can't help much because I am horrible with it; but with dimensional there are a lot of useful functions you can use to do this just depending on how your data is stored.  I would start off by trying to use something like:
lastPeriods(12, ?Prompt?)