Wondering if what I'm trying to do is possible.
In the third expression below I would like to count all free units per BIL_ID, but doing so by month. Obviously it works if I replace the Date_MonthYear dimension with BIL_ID... But I would like to see that per month instead.
So, I've tried this expression using the Aggr function, but that doesn't work:
=Aggr(If(Sum(NetRevenue)=0, Sum(Quantity), 0), BIL_ID)
Is it possible to do what I'm trying to do in this way?
Thank you for your help!