Pick match with aggr in bar chart

[shahafei2]

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**

[shahafei2]

?

[Brett_Bleess]

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