Hi,
I am adding several calculated fields to pivot table in Excel 2013 with no problem and result is calculated correctly.
Now I need to add IF Function to the last column in the pivot table and insert IF Function into it.
I've already added a calculated field titled Sum of Balance and it is the result of Credit - Debit.
The field I want to add suppose to be titled Status and the IF Function has 3 results:-
If value of the Sum of Balance Column = 0, then Status calculated field should equal to BALANCED
If value of the Sum of Balance Column > 0, then Status calculated field should equal to Credited
If value of the Sum of Balance Column = 0, then Status calculated field should equal to Debited
https://www.dropbox.com/s/tnschp4f8or8c8q/Balance_Debit_Credit.xlsx?dl=0
Thanks
- Moved by Lanlan HuangMicrosoft contingent staff 26 minutes ago