10 Replies Latest reply: Jan 18, 2015 7:11 PM by Sheetal Panchal RSS

    Background color in Pivot Table based on condition

    Sheetal Panchal

      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,