Whenever I create a pivot table, Excel has a nasty habit of always (wrongly)
assuming function COUNT to apply to any data placed in the pivot table, even
if the data is purely numeric.

How do I permanently fix Excel's cretinous obsession with counting and
replace it with the required function?