Table Chart Req

[Purushothaman]

Hi Experts,

Below is my requirement: Need to do this Brand Listing on the front end if possible or if not can do it backend script.

RollsRoyce Should in First Row ( despite of any amount sum of USD)

Second Row "brand name"    (which is based on 1st  Highest  amount sum of USD )

Third Row "brand name"    (which is based on 2nd  Highest   amount sum of USD )

Fourth Row "brand name"  (which is based on 3rd  Highest   amount sum of USD )

Fifth Row " Brand Name"  ( which is based on 4th Highest   amount sum of USD )

Others is rest of the brand Sum

Below are the case scenarios for better understanding:

 Anyone, Please help!! 

Thank you!!

[prasad_dumbre · Accepted solution]

Dear Puru,

It would be better you achieve this in backend as then your frontend expressions would become simpler and results in better performance.

Please find the attached .QVW with solution. 

Mark answer as right if it is so.

[Purushothaman]

Thank you sir for your quick help. I will look it to it.