Pivot Conditional Formatting based on another value

Q&A
, , ,
1

Hi there, I am currently working with pivot tables and would like to have some conditional formatting. It needs to check another field and if the value is less than current, show an up arrow, if less, show a down arrow, otherwise a line.

I created a calculated function

ifelse(7dayrevenue > 30dayrevenue ,-1, ifelse(7dayrevenue < 30dayrevenue ,1, 0))

Then i added conditional formatting

image
image243×766 21.8 KB

Unfortunately this didn’t work. Any insight would be greatly appreciated.

2

Welcome @boss,
did you check if the calculated field is working as expected?
BR

3

Thank you, I identified it was incorrect in my calculated function.

4

You’re welcome.
Can you mark it as solved then?