Pivot table double from source

[ursula1]

Why is the total doubled in the pivot table from the source data? i.e. the source show 150 but the privot table shows 300.

I have used pivot tables for a while and never had this trouble. I use Excel 2003

 

[ursula1]

OMG. Thank you all for your help and patience. I did not realized that I had subtotals. I feel like such a fool.

Thanks again to everyone for your help.

Have a great week and stay safe.

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.