Calculated field in Pivot table - Numbers
I have a main sheet where all my account transactions are listed. There is a pivot table with the sum of all my spending and earnings. I want to create an expense ratio to understand the data better.
The data shown is not real.
After adding the expense ratio (with the formula Withdrawal amt/Deposit Amt), it should look like
Please guide me on adding a calculated field to a pivot table or the preferred ways to achieve the expense ratio.
Thanks in advance :)