Table Chart Requirement

[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.

Need your expertise to accomplish this. I have attached the dataset for your reference. 

Anyone, Please help!!

Thank you,

[Vishal_Gupta · Accepted solution]

You can try creating a new column like this

If(Brand ='Samsung', Dual('Samsung',1),

If(Brand='Apple',Dual('Apple',2),

..... Till MI/Redmi value and in final else condition you can put Dual('Others',6) as New_Brand

Create a straight table with New_Brand as dimension and sum of sales.

In sorting properties sort New_Brand as numeric expression ascending order.

This should give you the required result.

[Purushothaman]

Hi @Vishal_Gupta ,

Thanks for the quick help.  There is a small change in my requirement is:

SAMSUNG 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 my case scenario for better understanding:

Thank you!