In the attached workbook, I'm trying to show the aggregate profit ratio for all customers within a tier by sales (i.e. are high-sales customers more profitable than low-sales customers). I thought this would be straightforward -- a reference line by cell showing the Total for the calculated field. However, it seems that I am only able to show the Total for one of the cells.
I suspect the issue is that I am segmenting the aggregation based on a calculated field (I wasn't able to fix the error by using IF .. THEN statements as opposed to adding logical statements).
Please let me know if you have any thoughts on this.