How to extract data for 2012 Quarter 1, Quater 2, and Quarter 3?

[lookingforK]

Hi,

I am creating a list to extract data using Cognos Report Studio 8.

The columns in the list are:
Store   YTD Sales    Quarter 1 Sales   Quarter 2 Sales   Quarter 3 Sales
.......
.......
.......

I filtered the data with only 2012 months, e.g. Jan. ~ Sep in 2012.

I used the following expression for Quarter 1:

Code Select Expand

[color=red]if ([...].[Deal Dimension].[Month] in ('JAN', 'FEB', MAR')) then (total (Sales Count)) ELSE (null)[/color]

But I got the same values as those of YTD.

I am wondering:
* What expressions for Quarter 1, Quarter 2, and Quarter 3 I can use?
* Is there a WHERE Clause with Report Studio? (So I can use an expression like

Code Select Expand

(total (Sales Count) where ([...].[Deal Dimension].[Month] in ('JAN', 'FEB', MAR')) for Quarter 1, and so on)


Thank you in advance.

[tjohnson3050]

Create a data item with an aggregation property set to total.

In the data item use a case statement:

case when ([...].[Deal Dimension].[Month] in ('JAN', 'FEB', MAR')) then (Sales Count) else 0 end

Create a similar data item for Q2 and Q3

[lookingforK]

Thank you tjohnson3050,

It works.