condition in dimention

[#1]

Hi

i have data table with fields: "Country", "Week", "Sale"

and i want to create expression like:

=sum({<Week={"=2011W01"},Week=>} Sales)

in this field i want to get data only in week = 2011W01 Another weeks must be = 0

please see attachment

if anyone know, pltase help.

[kaushiknsolanki · Accepted solution]

Hi,

Just remove the "=" sign and the last filter.

Your expression should be like this.

Sum({<Week = {"20122W01"}>}Sales)

Cheers

Kaushik Solanki

[#3]

thank you!