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.
![sharmi1990_0-1670900571766.png sharmi1990_0-1670900571766.png](/t5/image/serverpage/image-id/96027iBA155775399F8BEB/image-size/medium?v=v2&px=400)