Greater than logic on Pivot Table

[#1]

Hey Developers - I have a problem

I need to be able to change the background colour if the participation rate on the week / month post the previous week / month is greater in green or red if below.

Cannot seem to get the expression right ?

Any help will be much appreciated

Using : =If( Column(0)>Column(1), LightRed(), Green()) at the moment.

[#2]

well there is nthing like column(0), u start with column(1), it might help.

But still i dnt understand which columns u wish to comapre in the screenshot and where do u want green/red.

please explain.

Regards

[#3]

Hey there - thanks for the response.

Sorry Typo !

I ended up using - =if(Count ([TOTAL CHARGES])>= Before( Count ([TOTAL CHARGES])), LightGreen(), LightRed())

and it worked.

I wanted to compare the next column with the previous column in the PIVOT table.

[#4 · Accepted solution]

Yes, using 'below' would solve your solution