Hi all,
I'm trying to create a grouped bar chart with the following dimensions
Date,
Category
and with a calculated expression that contains few varibels(one for each brand) and should calculate the sales forecast (roundup)
In general, I was using the below expression for such an expression but since I have two dimensions it seems that the expression can not affect them both as it is
sum(ceil((Line_Value)*
pick(match(Brand,'A','B','C','D','E','F','G'),
$(vA),
$(vB),
$(vC),
$(vD),
$(vE),
$(vF),
$(vG)),1))
any advice?