Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI,
Sum(Sales) and Sum(Margin)
Sum({<Year=,Week=>}Stocks), can't get the latest information available??
Hope it helps