Plotting percentages in a Pivot Chart

[DennisB]

Hi

I have a query that has 4 calculated fields that divide 1 number by another
to get a %.

I am using the query as the data source for a pivot chart but I am unable to
get the data to display properly. I have tried formatting the query
calculated fields as percentages, as numbers, with 0/2 decimals, and have
tried dividing by 100/1000. Nothing seems to work.

Can someone tell me what I am doing wrong?

 

[Atif]

Hi,

There should not be any problem, I have done this by creating a calculated
column and changing its format to Percentage.

Filed : Percentage: [Signed]/[New Business]
Total: select Expression from Drop Down
format the column as "Percentage" by Right Click and selecting "Properties"

Atif