Calculate Percentage based on range of associted values

[sekharQV]

Hi All,

I want calculate percentage based on range of unitno's that are associated with contract number.

I have attached my sample excel file and QVW which will explain more better about my concern.

I used dummy data here and i am getting actual data from db.

Please have a look and help me.

Thanks & Regards,

Sekhar

[Frank_Hartmann]

See  Vineeth Pujari ´s  solution. I think this is what you are looking for!

[qlikview979]

Hi

It will exact output  please   check the attached file .

[Anonymous]

Hi,

Can you try this

Aggr(sum(Cost)/Sum(Sales),ContNo)

[vinieme12]

a good read

When should the Aggr() function NOT be used?