Hi all,
I have a straight table that contains a Group dimension and the following expression
pick(match('A','B','C','D'),
sum(aggr(sum(XYZ),Item,Group))*vA ,
sum(aggr(sum(XYZ),Item,Group))*vB ,
sum(aggr(sum(XYZ),Item,Group))*vC,
sum(aggr(sum(XYZ),Item,Group))*vD)
This expression returns the expect result
I'm trying to have another expression that will look like
sum(aggr(Vol*
pick(match('A','B','C','D'),
sum(aggr(sum(XYZ),Item,Group))*vA ,
sum(aggr(sum(XYZ),Item,Group))*vB ,
sum(aggr(sum(XYZ),Item,Group))*vC,
sum(aggr(sum(XYZ),Item,Group))*vD)
,Item,Group))
But this expression returning 0 for all records
any suggestions?