Share via

Pivot Table - Duplicate values causing total to be wrong

Anonymous
2022-01-27T12:17:03+00:00

Hi,

I have a pivot table that shows the value of orders and when the orders where dispatched.

The problem is if the order was dispatched at different dates it add the order twice see below. This throws of the total

Because the part was part dispatched on the 19th and the seventh this is coming up at 20.74 instead of 10.37

Any help to make one of these numbers disappear would be great thanks

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz365 38,201 Reputation points Volunteer Moderator
    2022-01-27T13:53:05+00:00

    (issue also raised here)

    Hi Breandan McCann

    Assuming data in Table1, does the Pivot Table reflect what's expected in term of Totals ?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments