0 Replies Latest reply on Mar 12, 2013 8:50 AM by David Phillips

    "Total" reference line by calculated field

    David Phillips

      Hi all,

       

      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.

       

      Thanks in advance for your time,

      David