Create Query Calculation in a Crosstab - C8 Report Studio

I have a crosstab report with Year across the top and Month nested under that and two measure nested under that ( Net Revenue and Test Quantity). Down the side is Client, sub client and product nested in that order left to right.

At the far right, I have a summary of total Test Quantity and Total Net Revenue. I am looking to add to the right of that a Query Calculation to calculate Average Unit Price. The calculation is total Net Revenue/total Test Quantity but it does not return correct results. Any help is appreciated.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.