showing percentage instead of numbers in charts

[arixooo123]

hello dears,

i got a question, i already have a bar chart which shows the number of customers for each products,

the script for this chart is so easy, i have added Products field as dimension, in the expression i wrote count(Customers).

but i want to see the percentage instead of numbers. if i write the script like this:

count({<Product={A}>}Customers)/Count(Customers)

it shows the percentage of customers who bought Product A, but not every products.

thanks for your help in advance

[tresesco · Accepted solution]

Try like:

=Count(Customers)/Count( Total Customers)

Then in the number tab, check 'Show in Percent(%)' .

[arixooo123]

Interesting, thanks buddy. i had not heard the Total term before.