Help with SET-analysis - Choose not selected value

[#1]

Hi,

I have an app where a specific period is selected (lets say period 2).  But in one of all reports I would like to show period SALES for all periods (1,2,3,4,5,6,7,8,9,10,11,12).

When I use " SUM ({$ <Månad={'03'}>} SALES) " for period 3 it gives me 0. That is because I use $-sign.

But if I try to use " SUM ({1 <Månad={'03'}>} SALES) " I get all Sales (disregarding all other selections) for all years for period 3, but I would only like to have sales for the Year selected.

Please help me with this SET-analysis.

[#2]

Use:

Period =

blanking the period will ignore that particular selection

[CELAMBARASAN]

Hi,

     Try using this

     SUM ({<Månad={'03'},PERIOD=>} SALES)

Here "period=" excludes selection only in that field.

Celambarasan

[#4]

Hi Tobias,

              The equation will be something like this...

             SUM ({1 <Månad={'03'},Year='{$(vYear)}'>} SALES)

Set the variable to Year value i.e you have to put a trigger on Year 'select' where you have to set the variable 'vyear' .This equation is valid if you want a chart for a particular year selected and Period=3.

If you want it for year selected but for all the periods then:

              sum({1<Year='{$(vYear)}'>} sales)  

Let me know if  you need any further help.

Regards

Navin.G