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