Help with set analysis

Wed, 25 Jul 2012 20:05:05 GMT

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,

Re: Help with set analysis

MayilVahanan — Wed, 25 Jul 2012 20:11:31 GMT

HI,

Sum(Sales) and Sum(Margin)

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

Hope it helps