Calculated field in Pivot table - Numbers

Question

Level 1

4 points

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 :)

Posted on Apr 3, 2023 8:45 AM

Reply

Answer 1

SGIII

Level 8

37,538 points

Apr 3, 2023 9:44 AM in response to Shanthosh05

I don't see a way of doing calculated fields in a Numbers Pivot Table.

One thing you can do, of cours, is copy-paste the cells from the Pivot Table into a regular table and apply a formula there. Not fully automatic, but quite easy, especially after the Pivot Table has done the heavy lifting of calculating subtotals by month.

SG

Reply