I am truing to use filter in specific order, first filter out all sub accounts to 100 and than find max year_dt, can someone please help me with the expression?
Thanks
Z
Calculations:=CALCULATE(
SUM(Inv2018T[Custom]),
FILTER(
ALL(Inv2018T[YEAR_PD]),Inv2018T[YEAR_PD]=
MAX(Inv2018T[YEAR_PD])),Inv2018T[SUB_ACCOUNT]="100")
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Thanks
Z
Calculations:=CALCULATE(
SUM(Inv2018T[Custom]),
FILTER(
ALL(Inv2018T[YEAR_PD]),Inv2018T[YEAR_PD]=
MAX(Inv2018T[YEAR_PD])),Inv2018T[SUB_ACCOUNT]="100")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | YEAR_PD | SUB_ACCOUNT | DESCRIPTION | FAC | DEPT | SECT | AMT | YearPerStoreSect | Spread2018T4.% | Custom |
| 2 | 2018 04 | 312166 | INVENTORY | 8 | 301 | 301 | 2018 040008301 | ($160,886.00) | ||
| 3 | 2016 07 | 100 | INVENTORY COUNT | 8 | 301 | 301 | 139441 | 2016 070008301 | 65.29% | $139,441.00 |
| 4 | 2016 13 | 100 | INVENTORY COUNT | 8 | 301 | 301 | 149026 | 2016 130008301 | 64.39% | $149,026.00 |
| 5 | 2017 07 | 100 | INVENTORY COUNT | 8 | 301 | 301 | 146470 | 2017 070008301 | 65.12% | $146,470.00 |
| 6 | 2017 13 | 100 | INVENTORY COUNT | 8 | 301 | 301 | 139369 | 2017 130008301 | 65.11% | $139,369.00 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
