Aggr Total question

[qlikconsult]

Hi

I'm looking for the correct expression in a pivot table to get the following result

I'm asuming that I have to use the aggr function and that I also have to add total to the expression, but when I try for example the following expression

=aggr(sum(total if(_year=Vyear AND accountGroupCode_mast='A' AND cat_move='MET' AND type_move='Forecast' AND accountDriver_mast='COSTING HA', value)),Fruit,Account)

i get the result

Any ideas of how I should change my expression will be greatly appreciated

Regards,

Jan-Hendrik

[mangalsk]

Welcome