If you are in a pivot and you have display results switched on, do not change the aggregation type before the result comes back. If you do it will not remember the change. It defaults back to the previous a type,