Hello Cognos Gurus!
I have an Amount column in my report that displays the amount for an executive based on the Month and Year input parameter value. So I have two input parameters ?P_Month? and ?P_Year?. I need another column that calculates this amount on a Year to Date basis. This Year to Date calculation should not be on the current sysdate. It should be based on the input parameter value i.e, if I run the report for March 2014, the YTD column should be calculated only until March 2014 and not the sysdate.
So this is how the report is supposed to look like.
Exec Amt for June2014 Amt (YTD)
A 232 3343
B 987 5466
C 124 1246
Thanks a lot for the help in advance!
Hi,
So you have already one query having Year month filters right.
Just Copy paste the same Query make the name as YTD Query
As you know every month is starting from one only....
in YTD query make the Month filter like below
[month] between 1 and ?P_Month?
year filter is same as your query..
now join the two queries on Executive data item.
Thanks & Regards
Sateesh Chapparapu
Mumbai
Thanks a lot Sateesh! Worked like a charm!