to calculate rolling 3 months data from the reporting month.(Last Month).

[biswasarijit84]

hi i am new in cognos. plz help me coz ihave a requirement : 1. to calculate rolling 3 months  data from the reporting month.(Last Month). in which component i should create and save it? 

[Suraj]

first calculate current month number (1-12) from sysdate or whatever.
Then filter query like this:
[month column] >= [current month number] -3
and
[month column] <> [current month number]

If you don't have month column to compare, you need to extract that from your existing date column.

[sdee_sekaran]

Use the Extract function add_months(Extract(?paramdate?,month),-3).