aggregate sum populate every data row

[wynnjimbbt]

need the aggr(sum() below to populate every data row in a chart to calculate [Client Rank] within [Plan Type]

numerator:

     =aggr(sum({$}[Market Value]),Client,[Plan Type]); this works

denominator calculation is correct but I need it on every data row

     =sum(aggr(sum({$}[Market Value]),[Plan Type])) //this is the correct 

[Arthur_Fong]

Try to add 'Total' in your denominator:

sum(total aggr(sum({$}[Market Value]),[Plan Type])) 

[Brett_Bleess]

See duplicate post: https://community.qlik.com/t5/New-to-QlikView/aggregate-sum-populate-every-data-row/m-p/1628233#M381...

Regards,
Brett

[wynnjimbbt]

Thanks Arthur but this returns the Grand Total on every data row.
I need the sum of Market Value Aggregated by Plan Type, on every data row.

Thanks,

Jim

[Brett_Bleess]

Jim, just in case Arthur is tied up, have a look at the following Design Blog post, it may help you out on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

[sunny_talwar]

Try this

Aggr(NODISTINCT Sum([Market Value]), [Plan Type])