Hi all,

I'm trying to apply a Top 10 items conditional formatting to a pivot table field. The issue I am having is that the formatting updates based on row filters i.e. I have 100 items in my row labels field and if I filter to 10 items then all of these items are highlighted which makes the formatting meaningless. Essentially I would like the conditional format to apply to the whole data set, not just what is displayed using the row label filter. Any ideas?

Thanks