To display just the number (not % symbol) on Pie Chart

[montubhardwaj]

Hello everybody,

I have a little problem with Pie chart. I will explain in detail below:

I have a pie chart which is showing the propotionate values (say % sales for each dept).Please see below for snapshot:

I want to show just the number on the pie and not the % symbol i.e i want to show only 76.64 instead of 76.64%. How can i achieve it ?

In the dimension part, I am using "Dept" and below is the expression:

sum

(aggr(if(sum(sales) <0,0,sum(sales)),Dept))

Also to show the % Sale of each dept to the Total sale, I have checked "Relative" option in expression tab.

Also, In the Numbers tab, I have checked "Show in %" option and fixed to two decimal places.

Please advise me how I can achieve this?

Cheers,

Dinesh Sharma

[#2]

I cant understand you....

you wanna show a value of sales, just uncheck a relative option and Show in %.....

did you make this and still in %?

[#3]

If you unchecked "Show in %", you need to change your expreesion.

Example:

(sum(Sales) / SUM(TOTAL Sales)) * 100

The pie chart show the format that you want

Do yout can upload your example?

[montubhardwaj]

Hi Eduardo,

I changed the expression as you suggested and it WORKED perfectly....

Thanks much!!

Aleixo,

Thanks for having a look on it and giving ypur opinion.

Cheers,

Dinesh Sharma