P&L pivot with color for two difference performance

[simonegabrielli]

Hi there,

I have to use a P&L pivot to represent different KPIs. The problem is that with P&L I can just set the colors for one performance, but I have to set:

• Green color for CapEx < 0 and Red color for CapEX > 0,  
• Green color for another KPI when is > 0 and Red color when is < 0

is set analysis a possible solution ? or maybe it can be the style csv that I use for  style template formt ?

thanks for your time 

[chrismarlow · Accepted solution]

Hi,

I think you can only do the cell colouring you want with a table (unless someone has come up with an extension that does more colour options), but then you lose the ability to pivot & drill in.

Cheers,

Chris.