Share via

Excel Pivot table shows incorrect count value

Anonymous
2016-10-18T18:58:05+00:00

I am new in creating pivot table. I tried a simple case of creating a pivot table to count types of fruits in two different baskets. My original table is 

Basket1 Basket2
apple apple
apple apple
orange orange
pears pears
pears mango
mango mango

When I created the pivot table, I see the first column values are correct but the second column is incorrect. The Pivot table is as below,

the second column is copy of first column.

Row Labels Count of Basket1 Count of Basket2
apple 2 2
mango 1 1
orange 1 1
pears 2 2
Grand Total 6 6

Pivot table fields are

What am I doing wrong?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2016-10-19T11:17:24+00:00

    HI,

    For better assistance, you may post your concern here. Just select Community > Forums > View All > Type in “Excel” then select the appropriate category.

    Feel free to contact us if you need assistance with Windows.

    Was this answer helpful?

    0 comments No comments