Percentage of the total values in a column

[sanimesa]

Is there a generic way to create a percentage of total column next to an aggregate column? As an example I have a table with customers and the aggregate total of orders of each customer. How can I add a percentage of total? I have seen solutions that create measures which hard code allexception columns etc. but I have other filters that may get applied and it makes it difficult. 

Customer           Total Sales $         %of Total Sales

ABC                    100                       20%

DEF                     150                       30%

GHI                     250                       50%

Total:                   500                      100%

[Vvelarde · Accepted solution]

@sanimesa

Hi, you can add the Field again and change to show as % of Grand Total

The only "but" is that you can't change the decimals.

Regards

Victor

Lima - Peru