Screen Shot 2018-07-11 at 6.08.04 PM.png
Screen Shot 2018-07-11 at 6.07.50 PM.png
I have a table which summaries a list of purchases made by customers. In this table it has 3 columns, the customer ID, their max budget and the purchase amount. I wish to make a pivot table which shows compiles the sum of purchases for each customer and the % of their budget used. I had no problem making the sum of purchases amount but am having difficulty using a pivot table to make the % used field.
I've tried to make a calculated field using: = SUM( 'Purchase Amount ($)')/ 'Max Budget ($)'
But it does not take into account the sum of the purchase amount. It just uses 1 of the values from one purchase rather than a sum of all the purchases.
C1 should have 22% used (with 2 purchases) and C2 with 25% used (with 3 purchases) but instead it returns C1 with 11% and C2 with 8.33%.
Bookmarks