Microsoft Excel - Pivot Table/Rounding

Asked By Erika O'Brien on 23-Nov-10 01:59 PM
So, I am using one pivot table for multiple data pulls in a single file/spreadsheet.  Example I have 3 sites....Texas, Indiana, Utah.  I populate my pivot table to pull just Indiana info....paste it into another sheet.....I re-populate my pivot and do the same for Texas and Utah....then I create a pivot table to just pull Texas and Indiana.....off to the right of my pasted pivot information I have some formula's that divide....example Profit per Hr.  I think because the original pivot table is not rounding and carrying the number out to the 10th decimal....my numbers are slightly off.  So, hours of (288 +388)/(9438.44+6703.98) Profit = $23.88......my pivot gives me $24.52.  Do you think I am right and this is a rounding issue?  If so how do I fix?  E.
wally eye replied to Erika O'Brien on 23-Nov-10 03:15 PM
The difference would seem to be a bit more than Excel would give for a rounding error.  I would suspect you are not getting the raw data you think you are.  You probably should review the pivot tables when they populate against the data behind them to ensure they match your expectations.