Crystal Reports - Summarize Cross Tab Values
<p>I'm using CR12 pulling from a database and trying to create a summary that will total values in a cross tab.  Here is my scenario:</p>

<ol>
<li>Report detail shows equipment used</li>
<li>Detail is grouped by Room and then Date/Time of session</li>
<li>Summary section totals up all equipment with discounts, tax, etc.,(via formulas) ending in Grand Total</li>
<li>Grand total is then divided by a distinct count of billing codes to calculate avg. $ amount per billing code that is due per room/date-time</li>
</ol>

<p>This was placed in a cross tab to show Billing Code and $ Amount Due per billing code.  Now I need either another cross tab or summary at the bottom of the report to show the total amount due per billing code.</p>

<p><em>Example:</em></p>

<p><strong>Room/Date</strong>----<strong>Billing Code</strong>----<strong>Amount Per Code</strong></p>

<pre><code>101 3/2/16------ABC123----------------$50.00

101 3/2/16------DEF456----------------$50.00

102 3/2/16------ABC123----------------$25.00
</code></pre>

<p><strong>TOTAL</strong></p>

<pre><code>  ABC123: $75.00

  DEF456: $50.00
</code></pre>

<p>Here is a screenshot example of what I have so far:</p>

<p><a href="http://i.stack.imgur.com/rQ5LY.jpg" rel="nofollow">Report Example</a></p>

<p>Any insight provided is greatly appreciated.</p>