View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Problem with Pivot data

Double click on the 3 to drill into the data set. Take a look to see what you
get. Perhaps your data set has 2 instances of the same data.
--
HTH...

Jim Thomlinson


"Rajula" wrote:


Hi,

Have a certain data in the colum field in a pivot. The number displayed is
actually double the number in the datasheet.

Eg: xyx - 1.5 in the datasheet.
In the Pivot it shows xyz - 3.0.

Any idea how to resolve this?