Help with set analysis

[#1]

Hi everyone,

I'm assembling a report with different filters and a number of data sets. In one particular data set, I would like only one of the filters to apply.

Being more specific:

-I have, as filters, brand, year and week

-The reports beneath are sales, margins and stocks

-For sales and margins, all three filters apply

-For stocks, I would like only for the filter brand to apply, and it would return me the latest information available for stocks.

Can anyone help me in any way?

Thanks a lot in advance.

Cheers,

F.

[MayilVahanan]

HI,

     Sum(Sales) and Sum(Margin)

     Sum({<Year=,Week=>}Stocks), can't get the latest information available??

     Hope it helps