Dear,
I'm developping an application concerning the sales of the 3 first months of a car.
Something like this:
| Model | release date | Sales of the first 3 months |
|---|
| car 1 | 01/03/2014 | 1000 € (from 01/03/2014 to 01/06/2014) |
| car 2 | 02/03/2013 | 2000€ |
| car 3 | 01/01/2012 | 3000€ |
In a straight table.
I'm using the expression:
sum({< [Period]=,[Day]=,[Weekday]=,[Year]=,[Month]=,[Quarter]=,[_MonthSerial]=,[_QuarterSerial]=,[_WeekSerial]=,[Year-Month]=,
Period={">=$(=only(ReleaseDate))"}*{"<=$(=addmonths(only(ReleaseDate),2))"}
>} Sales)
It is working fine when I select 1 car in my list box but not when I want to see all my vehicles.
I tried with an aggr function in my set analysis but no results.
Thx for your help
