Background color in Pivot Table based on condition

[#1]

Hi,

I have 3 fields in my pivot table - Account, Credit/Debit and Amount. Pivot table has following dimension and expression:

Dimensions:

1. Account

2. Credit/Debit

Expression:

1. Sum(Amount)

Is it possible to color the background of a account where the credit and debit are not equal? Below is the requirement.

Thanks,

[#2 · Accepted solution]

To get the desired output, I multiplied the amount by -1 where it was Debit(which should have been negative in the data) and then enabled Partial Sum on the Account column. I then used below expression. This highlights the row where Total is not 0 (Credit <> Debit)

if(RowNo() = 0 and sum(Amount) <> 0, Yellow())