0

I couldn't think of a better title. Please bear with me!

I have the data as the following image shows:

data

I create a pivot table using the range 'Sheet1'!$A$1:$E$33. The table displayed is as follows:

pivot table

Why is the data skewed for only the set of Round 3 and no other?

Improve this question

1 Answer 1

Reset to default
0

I found the root cause of this behaviour. The cells in column A are of data type Number, with 0 decimals. I used autofill feature after selecting the first 8 cells, namely, the values 1 1 1 1 2 2 2 2. This caused the later values to be decimals like: 2.54, 2.78, 2.93 etc. These were getting rounded to 3 but since they weren't actually 3; pivot table was displaying them in separate rows.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .