Pie chart with number and percentage

[wendytham]

Hi,

I use the below expression to show number and percentage.

But, the total of % of the pie chart is not equal to 100%.

Please assist.

Thank you.

dual(NUM(SUM(Job)/SUM(Total Job), '#,##0%') & ' / ' & Num(SUM(Job), '#,##0'), Num(SUM(Job), '#,##0'))

[tomasz_tru]

I know it won't help here but this is may endless mission on fighting with pie charts

[jensmunnichs]

Is it far off 100%? If not, it might just be down to rounding.

[rajivmeher]

Hi Wendy

Do you have any NULL values in the dimension may be? Check if you are supressing NULL values for your Dimension?

Regards

Rajiv.