Pivot Table does not calculate properly!

D

Dave

I have a Pivot Table based on a linked query from SQL Server 2000 that
does not sum decimals correctly. The query displays values with
decimals correctly, but when this query is used as the source of a
Pivot Table, the decimals are truncated. This only happens on Pivot
Tables, as I have reports based on the same linked query that are
calculating correctly. It seems to be a problem with the data type of
the field I'm trying to sum. It is the decimal data type, and I've had
problems with this data type when using Pivot Tables.

Any ideas how to solve this problem?

Thanks,

DaveP
 
Top