Qliksense Pivot Table Color formatting

[singbittoo]

i have a  pivot table and in dimesion i am showing country, in columns i an showing months, and in the measure sum of sales,

my requirement is like if previous month sales is more compared to this month the color should be red else green

eg:

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9
	month 1	month 2	month 3	month 4	month 5	month 6	month 7	month 8
India	21	23	20	25	26	28	26	22
canada	32	21	46	56	6	67	56	67

so for this i wrote an expression like

if(Before(sum(Sales),1)<sum(Sales),'Green','Red'), it is working for most of the cases but failing many places.

any solution ?

[singbittoo · Accepted solution]

sorry, the above expression works fine my bad i had 4 expression which gets selected based on some condition, but in formatting condition i only wrote condition based on one expression