HI All,

I am currently working on the report which needs to sum on a particular column based on the year and quarter selected.example- if the selected year is 2010 and qtr is 2, then the report should run for 2008 all quarters, 2009 all quarters and for 2010 till 2nd quarter.

I tried giving "where year LE current year" and where qtr LE curr qtr" but this will give data for all years but only for 2 qtr. I also tried merging the columns "where yr||qtr LE 20102". nothing seems to be working.
Can anyone please tell me is there a way out for this
Thanks
Shru

This message has been edited. Last edited by: Kerry,

Have you considered putting your data selection logic in DEFINE?

Maybe something like this:
where year lt xxxx or (year eq xxxx and qtr le y)
xxxx is the selected year, y is the selected quarter.

Hello Everyone!!!!

Thanks for all your inputs. The issue is resolved.
I used 2 conditions to resolve the issue
where year eq 2010 and qtr lt 2
where year lt 2010
this gave the result what i wanted

If you have a your date and quarter in a smart date, you can test directly.

TABLE FILE GGSALES
PRINT *
COMPUTE Qtr/YYQ = DATE ;
WHERE TOTAL Qtr LE '1996 Q2'
END