Unable to color conditional formatting

[#1]

Hi,

I am a novice in Qlik Sense.I have created a pivot table similar to the table below.

A	B	C	D
new york	12.6%	50
London	14.5%	70
Paris	15%	80
Total	13	60

Here I have created the total row through the slider option in general tab.

now I have to condition format each column for eg:
if  value in B is >total's 90% then green if below totals 10% then red.
Hope my explaination helps I am not able to find solution in any of the qlik community discussions.

I ahve a deadline to meet if anyone could Please help me on this.

Regards

Vinayak

[rupamjyotidas]

Add your condition under

Background color expression

https://help.qlik.com/en-US/sense/June2017/Content/Videos/Videos-pivot-table.htm

[#3]

HI Rupam,

I am using color by expression but I have issue creating the expression for it

as I am unable to create an expression to compare the total of the column with the value
eg if the total is 10% and my value is 9% then it should be green if it is 1% then it should be red.

Regards,
Vinayak