I'm trying to create a KPI by applying the sum to the particular fields in a column. I want Order Type = Clothes, shoes, pants to group and take a sum by most recent date.
I applied this formula and it is working fine Sum({<Date={"$(=Max(Date))"}>}Order Type='Clothes')
But I'm getting output in a negative (minus). I'm not sure why it is doing this. It is giving me -96 instead of 96.
Secondly, how can I combine another order type in the same statement??
Sum({<Date={"$(=Max(Date))"}>}Order Type='Clothes', shoes', 'pants') This syntax is not working when I'm combining order type)
