How to get totals and percentage for top 3

[trdandamudi]

Can someone please assist me to get total and percentage for top 3 records. The file is attached with sample data and the required final output.

Thank you.

[sunny_talwar · Accepted solution]

Check the attached

[trdandamudi]

Perfect Sunny.... This is what I need.

Thank you..

[sunny_talwar]

Awesome

[trdandamudi]

Sunny,  a quick question:

When I open your attachment in QV 11.20 SR9 everything looks good, if I open it in QV 11.20 SR13, the table shows as below:

Any idea, how I can suppress '-' rows?

Thanks

[sunny_talwar]

This seems like a version issue, don't think I have a solution for this.....

[trdandamudi]

ok. Thanks...

[sunny_talwar]

Please close the thread by marking appropriate responses and any helpful responses.

Best,

Sunny

[trdandamudi]

Sunny,

On my  side it shows that I selected the correct answer. Am I missing something ?

[sunny_talwar]

You have marked your own response as the correct response . Is this what you wanted to mark as correct?