pick match in grouped bar chart's expression

[seWork]

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?