pivot table conditonal formatting based on 80/20

Fri, 31 Oct 2014 09:05:33 GMT

Hi,

Is it possible to do conditional formatting of a pivot table based on 80/20 percentage. For example I have a pivot table as below. It is showing the cost values by category and country

want three kind of conditional formatting based on 80/20 expression

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)

I will appreciate if someone can help me in this as I am struggling to find a solution for this

Shah

topic pivot table conditonal formatting based on 80/20 in QlikView

pivot table conditonal formatting based on 80/20