Good Morning !
Is there any way to add the "Total Fruit" as a Calculated Field to the Pivot table ?
It would have the total for all fruits on that row.
Pivot Table:
Data :
Is there any way to add the "Total Fruit" as a Calculated Field to the Pivot table ?
It would have the total for all fruits on that row.
Pivot Table:
Data :
| Date | Type | Specific | Total | Sold |
| 11/25/2022 | Fruit | Apple | 30 | 15 |
| 11/25/2022 | Fruit | Orange | 30 | 18 |
| 11/25/2022 | Fruit | Papaya | 30 | 25 |
| 11/25/2022 | Fruit | Apricott | 10 | 3 |
