Greetings.
I have a dimension D_CODE which has multiple values like Z1, Z2, Z3, Z4
My expression is
count({<UID={"=alt(aggr(sum({<D_CODE-={D_CODE}>}D_MIN), UID),0)<=15"}>}distinct UID)
is there a way to reference the value of D_CODE in the expression, so that the expression is now:
D_CODE |
Expr |
Z1 |
count({<UID={"=alt(aggr(sum({<D_CODE-={'Z1'}>}D_MIN), UID),0)<=15"}>}distinct UID) |
Z2 |
count({<UID={"=alt(aggr(sum({<D_CODE-={'Z2'}>}D_MIN), UID),0)<=15"}>}distinct UID) |
Z3 |
count({<UID={"=alt(aggr(sum({<D_CODE-={'Z3'}>}D_MIN), UID),0)<=15"}>}distinct UID) |
Z4 |
count({<UID={"=alt(aggr(sum({<D_CODE-={'Z4'}>}D_MIN), UID),0)<=15"}>}distinct UID) |