Hello,
This is an example of what my data looks like:
Name|Counts|Amount
John|1|100
Fred|2|200
Bob|3|400
John|4|500
1. I need the Average Amount. How do I take the Amount and Divide by the Grand Total of Counts? Because there's filters on the data, when I 'Summarize Values by AVG' it calcualtes the Average for every John, Fred, Bob in the Pivot.
2. I created another column outside the PivotTable to manually calculate things. How do I ensure the PivotTable format aligns with this column? When I apply a new filter, the manual column will change and doesn't align with the Pivot Table Subtotal formatting etc.
Thanks,
Sharp.
Bookmarks