Hi All,
I have a pivot table, where data is aggregated at multiple levels. I have added color coding to the lowest granular level. As we roll up the pivot table, I dont want the color to be applied at aggregated level.
Eg: As you see below PIVOT table, I dont want the aggregated data ie. 12.35 and 11.94 to be highlighted, even though the underlying granular data in those categories are highlighted in red.