How can I change the number of decimal places displayed in a pivot table without changing source data?
How can I change the decimal places in pivot tables without changing the source table?
Different pivot tables require different accuracy i.e 2 decimal places or none so I can't change the source data.
It seems very odd to restrict data views formats to only the source data's format.