Hello,
My table is:
| WH | Date1 |
| WH1 | 01.01.2013 |
| WH1 | 02.01.2013 |
| WH2 | 03.01.2013 |
| WH3 | 04.01.2013 |
| WH3 | 05.01.2013 |
| WH3 | 06.01.2013 |
| WH4 | 07.01.2013 |
My goal is to show max date of currently selected Warehouses (WH)!
For selected WH3 and WH2 I want to see: Last record for WH3 - 06.01.2013, WH2 - 03.01.2013
For concat dates I've played with this(does not work):
Concat(Aggr(Date(RangeMax({1<WH={"$(=WH)"}>} Date1)),WH),',')
