Pivot tables: conditionally formatting based on all cells total

Q&A
, ,
1

Hi

For a sample pivot table as per picture

image

can anyone please let me know if there is a way to do conditional formatting where the lower values are colour coded separately to the higher values relative to all the other values in table (similar to the picture)? I need this to be applied across all the values in the table.

Thanks!

2

yes you can make a calculated field and conditionally format by it.

Something that might work is a percent of total, or you would need to build out your own logic.

image
image894×717 46.2 KB

3

Hi Max - thanks for the suggestion. In the real table I would have 10+ columns, so would your solution involve creating 10+ percentageOfTotal calculated fields or is there a more efficient way? Thanks

4

You would have to do that if you want to have conditional formatting like above for each.