Pivot Table Subtotals?

Lister00

New Member
Joined
Mar 12, 2018
Messages
4
Hi all

I use pivot table subtotals and there are not normally a problem. However I have a subtotal that when set to SUM is correct, but when set to AVERAGE, MAX or anything else = 1. Which is obviously not the correct value.

Anyone know why?
 

Forum statistics

Threads
1,082,586
Messages
5,366,476
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top