AGGR in Chart

[geam1988]

Hi, I have a table like this

I want to have report like this

but i am not able to get the proper result in QLikView report.

Qlikview report             

i am using following expressions for Group value =  

if i write the expressions as Calculated dimension. that works fine. but with that i can not get  %. I can do group by in Load script but i want to do it in Chart. Is it possible? Any suggestion will be highly appreciated.

Thank

Kazi

[Frank_Hartmann · Accepted solution]

Dimension:

Sales Person

Exp for "Group value as Expression"

sum(aggr(sum(Total <Group> [Sales Value]), Group,[Sales Person]))

Exp for "%":

sum([Sales Value]) / sum(aggr(sum(Total <Group> [Sales Value]), Group,[Sales Person]))