Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm trying to compare calculated forecast data and current data in a bar chart
In order to see similar chart to:
I'm using:
Dimension = Weekday(Date)
Expressions =
-QTY = (sum({<Inv_Type={'1'}>}[Qty])+SUM(DISTINCT{<Inv_Type={'2'}>}Qty2))/count(distinct week(Date))
-QTY *=pick(match(Inv_Type,'1','2'),
Ceil(
SUM(AGGR(
pick(match([M.customer group],'A','B','C','D'),
SUM(Qty)*(1+$(v_Factor_A)),
SUM(Qty)*(1+$(v_Factor_B)),
SUM(Qty)*(1+$(v_Factor_C)),
SUM(Qty)*(1+$(v_Factor_D)),
),[M.customer group],Inv_Type,WeekDay(Date)))
,1),
Ceil(
SUM(AGGR(
pick(match([M.customer group],'A','B','C','D'),
SUM(Qty2)*(1+$(v_Factor_A)),
SUM(Qty2)*(1+$(v_Factor_B)),
SUM(Qty2)*(1+$(v_Factor_C)),
SUM(Qty2)*(1+$(v_Factor_D)),
),[M.customer group],Inv_Type,weekday(Date)))
,1))
But for some reason, the Qty* calculation is not shown
any ideas?
**The qty expression is presented only**
?
Shahaf, likely going to need to attach the app or a sample app with data model etc. in order for someone to pose any ideas on this one...
Regards,
Brett