Pivot tables shows wrong value

Question

Hi there,

For my job I have created a system in excel in which everybody in the company has to report their sales. For each sale, the salesperson has to insert numbers in different columns which represent different things they could have sold. One of those categories is called 'mobility cards', something that we hardly ever sell.

For the overview I have created a dashboard using pivot tables, which all works great except for one things. On the dashboard, it says that two mobility cards have been sold. However, nobody has sold any mobility cards, so the value should be zero. When I click on value in the pivot tables, it also doesn't show any orders, but the table still gives the value two.

Does anyone know how that is possible?

Thank you in advance,

Pieter

Answer 1

Hi there,

I can't really share the file as my boss doesn't want anyone from outside the company to see our sales, which is fair enough.

However, I ended up rebuilding the whole dashboard to see if that would work, and it did. Now it gives the correct value of zero. I'm still unsure as to what happened, but as long as it keeps working I'm ok with it.

Many thanks for trying to help me!

Pieter

Answer 2

Hi,

Share the link from where i can download your Excel file.

Answer 3

Double click the value in the Pivot table (to perform a Drill Through) and Excel creates a new sheet with a table that lists all records which are behind that value.

I guess you count the values and there are blanks (or something similar) in the data cells which causes the "strange result".

If you need further help we need to see your file.

Andreas.