In regular tables, you can default each metric column separately. However in pivot tables, you can only choose one number format for the whole table, which makes it difficult to show both counts and percentages with the formatting required for these.