Hi,
Can you help me please to find the error in this expression :
=Max({1} Aggr(sum({$<[Due Year] ={">=$(=(max([Due Year])-($(V_YearBack)))) <=$(=(max([Due Year]) ))"},
Elapse={"<=$(=(Elapse))"}>}
Sales_$(V_Currency)), Elapse,
[Due Year],
[Due Month]))/1000
this expression returns the result below :
Due Year | Due Month | Elapse | Backlog |
| | | 58,558 |
| 2011 | 04 | -36 | 29,721 |
| 2012 | 04 | -50 | 11,706 |
| 2012 | 04 | -43 | 22,119 |
| 2012 | 04 | -36 | 33,758 |
| 2012 | 04 | -29 | 46,705 |
| 2012 | 04 | -22 | 47,495 |
| 2012 | 04 | -15 | 49,322 |
| 2012 | 04 | -8 | 49,926 |
| 2013 | 04 | -50 | 9,983 |
| 2013 | 04 | -43 | 21,439 |
| 2013 | 04 | -36 | 33,712 |
| 2013 | 04 | -29 | 45,932 |
| 2013 | 04 | -22 | 54,289 |
| 2013 | 04 | -15 | 57,664 |
| 2013 | 04 | -8 | 58,558 |
| | | |
What i want to see is sales for the Max Elapse ?
Thanks for your help
