Bar Percentage

[Salehmo]

Dear all,

I have a data containing sales per distributor and i need to get a graph showing the contribution percentage from the total per each distributor as in the below graph as we do in excel pivot chart (show % from grand total)

[Taoufiq_Zarra · Accepted solution]

Hi,

If I underestood correclty, you need :

num(sum(Sales)/sum(total Sales),'# ##0%')

for exemple, with the below sample :

Data:
load * inline [
Row Labels,Sales
EIMC,10
ETC,20
ISBNSINA,30
MEC,40
MULTIPHARMA,50
Overseas,10
Sofico,60
UCP,70
];

In Interface:

Dimension: Row Labels

Measures : num(sum(Sales)/sum(total Sales),'# ##0%')

output :