Straight table aggregation

[venkatg6759]

Hi Please go through the attached qvw and help me how can i get the table like this

Firm       Name              api                    Weighted                

1                 X                 ask_broker         41.09%

Just one line for the desired selection made  and also remove the N/A values and show the single line  that is total .

[Anonymous]

I think that is needed to see your .QVD.

Regards

[Anonymous]

I meant your .qvw.

[venkatg6759]

I cannot share my qvw instead i can give you excel attachment.How the calculations are performed .Please find the attachment