Mayanwolfe
New Member
- Joined
- Jun 5, 2013
- Messages
- 27
Hello,
I have a Pivot Table with Years as the top-level column, then two fields underneath, Cash and Operations. The values in each field are currently calculated as % of Parent Column Total, so Cash and Operations are shown as percentages of each year's total. I would like to also create a grand total for cash and a grand total for Operations that shows the average % for each across all years. For example, if Cash is 17.99% in 2019 and %18.90 in 2020, the Cash total field should show %18.44. I've attached a picture of the table as it currently exists (the structure is the same, real values have been changed), with the new fields that I want highlighted in yellow.
I assume I need a calculated field for this, but I don't have the slightest idea where to begin.
I have a Pivot Table with Years as the top-level column, then two fields underneath, Cash and Operations. The values in each field are currently calculated as % of Parent Column Total, so Cash and Operations are shown as percentages of each year's total. I would like to also create a grand total for cash and a grand total for Operations that shows the average % for each across all years. For example, if Cash is 17.99% in 2019 and %18.90 in 2020, the Cash total field should show %18.44. I've attached a picture of the table as it currently exists (the structure is the same, real values have been changed), with the new fields that I want highlighted in yellow.
I assume I need a calculated field for this, but I don't have the slightest idea where to begin.
