pivot table conditional formatting based on 80/20 percentage

Wed, 29 Oct 2014 08:22:33 GMT

Hi,

I have a pivot table where I have categories on rows and countries on columns. I have presented the cost by each category and country. Take a look at the below table for example

I want three kind of conditional formatting here

1) For each cell in row(Category), If the cost contributes to the 80% of total cost for that row, format the background to be yellow

2) In another copy of the same table, for each column (country) I want the background of a cell to be colored orange if the cost amount of that cell contributes to the 80% of total cost for that column (country)

3) In another copy of the same table, I want the background of a cell to be colored red, if it contributes to the 80% of the overall cost (All categories, all countries)

topic pivot table conditional formatting based on 80/20 percentage in QlikView

pivot table conditional formatting based on 80/20 percentage