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

[Anil_Babu_Samineni]

Remove TOTAL keyword and show the image what you are getting?

[qlikconsult]

Thanks for your interest,

this is what happens when I remove the TOTAL keyword

I need however the Account field's content also to show

[Anil_Babu_Samineni]

Oh, Okay. try a shot something like below

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

If not, Better if you provide excel or qvw ??

[antoniotiman]

Try this

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

[qlikconsult]

Thanks for your input,

I'm however getting the next result when I try your suggestion

need to see the field Account's detail also

[qlikconsult]

this is result from Anil;s suggetion

[antoniotiman]

Remove ,Account from Aggr()

[qlikconsult]

thx, this is the result I'm getting when i remove the Account field from Aggr()

need to see all the accounts in this field however

[antoniotiman]

Can You provide some sample data ?