Pivot Table doesn't count all data

Question

Everything in the table is mostly correct except the ones with the correct numbers on the right.

I kept refreshing the data, but it's still not giving me the correct data and I don't know why.

For the count, it's counting every status label that has the same name. Ex: Dispatch pending is counting 17 tickets in "dispatch pending" status.
There isn't a number value to add as a sum so it's just under "count" for the "Count of Ticket".

When I go back to filter each status, I count it and that's when I realized there was some incorrect data showing in the count tables.

Please help! It should've been pretty simple but I don't know why it's not counting all the data.

Answer 1

Hi @jellyfish

Welcome to Q&A forum~

According to your third image, in addition to the Status column, there are other columns in the source data.
Can you take a screenshot to show us your source data? (If there is any sensitive information, please remember to cover it.)

Currently, I would suggest you check the data range you selected for your pivot table.
You click one cell of pivot table > PivotTable Analyze > Data > Change Data Source, make sure all the data is specified.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---