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
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?)