1 of 1 people found this helpful
I think the picture shows you what you want, though you should check the numbers. I created a window sum of amount, set the compute to ID (on the details shelf), and then (the secret sauce) right clicked the agg(bundle) and deselected Ignore in Table Calculations. If you want to draw a chart around this we will need some extra code to stop the repetition/overlap caused by customer ID on the details shelf.
Thanks for your response! This is definitely getting there.
The chart mock up I had provided was totally made up numbers. I have uploaded one with the correct calculations. I am looking for the average per customer for each of the bundles. So, in the case of the' chairs, tables and stools' bundle that would be 101177/2=50588.5 since two customers purchased that bundle. The next piece of code would be to get this average number for each bundle and then plot the chart using that.
Thanks once again for your help!