topic Remove Qlik Pivot Table color coding at aggregated level in Reporting Service & Alerting https://community.qlik.com/t5/Reporting-Service-Alerting/Remove-Qlik-Pivot-Table-color-coding-at-aggregated-level/m-p/2015706#M472 <P>Hi All,</P> <P>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.</P> <P>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.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sharmi1990_0-1670900571766.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/96027iBA155775399F8BEB/image-size/medium?v=v2&amp;px=400" role="button" title="sharmi1990_0-1670900571766.png" alt="sharmi1990_0-1670900571766.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 15 Nov 2024 21:54:20 GMT sharmi1990 2024-11-15T21:54:20Z Remove Qlik Pivot Table color coding at aggregated level https://community.qlik.com/t5/Reporting-Service-Alerting/Remove-Qlik-Pivot-Table-color-coding-at-aggregated-level/m-p/2015706#M472 <P>Hi All,</P> <P>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.</P> <P>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.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sharmi1990_0-1670900571766.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/96027iBA155775399F8BEB/image-size/medium?v=v2&amp;px=400" role="button" title="sharmi1990_0-1670900571766.png" alt="sharmi1990_0-1670900571766.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 15 Nov 2024 21:54:20 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/Remove-Qlik-Pivot-Table-color-coding-at-aggregated-level/m-p/2015706#M472 sharmi1990 2024-11-15T21:54:20Z