Pivot Table - Duplicate Values

Question

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

Answer 1

Hi,

In the Pivot Table, change the function to MIN.

Answer 2

Hi @Breandan McCann ,
I created the sample about the PivotTable, as you can see the 10.37 is the SUM value for dispatched date, the 20.74 is the total SUM of all dispatched date for order date:

I'm not very understanding your problem, try to provide the data source and detail requirement, you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response is helpful, please click "Accept Answer" and upvote it.
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.