need to force PT to use formated number

[Guest]

I am generating charts from PivotTable reports. The tables take thier data
from a field that contains a =median() formula. The formula often gives
deicmal results (3.5 for example) and I use cell formating to round the
number to the nearest whole.

Whoever, the PivotTable refuses to use the rounded number and instead uses
the decimal result from the formula. I need the PivotTable to use the rounded
number and not the decimal number. Has any one had any experience with this?

Thanks,

David Russell
Software Support Analyst
School District 54

 

[Dave R.]

For your cell formula, you could use =ROUND(MEDIAN(A1:A10),0)

 

[Guest]

Ahh what wisdom, it works perfectly. Many thanks guru.