Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table conditional formatting based on 80/20 percentage

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

8020.PNG.png

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)

0 Replies