Crystal Report XI: calculate subtotal % of total

Question

I have a report that calculates a summary field by group location which I am calling a sub total. There is another summary field by company in group company section. We allocate corporate overhead costs based on volume of revenue. I need to take the location total revenue and divide by the overall company revenue to get the % of volume. My problem is that I cannot get the company total into the location group row without effecting the numbers. I have tried to create a running total field to get the total. I have tried referring to the main report to get the company total and I have tried summarizing the location totals but I cannot summarize a summarized field. Any suggestions would be really helpful, thank you!

Company Locations---------- Total Revenue-------- % of Volume

California------------------------ 500,000----------------- 500,000/950,000 ?

New York ---------------------- 300,000

Ohio ---------------------------- 150,000

Company Total: -------------- 950,000

This looks like the same thing I am trying to do but I don't understand the answer yet.. http://www.experts-exchange.com/questions/27749404/Crystal-Reports-XI-fixed-value-for-denominator.html

is the company total a running total? what kind of fields are your total revenue: summary, running totals or formulas? — cojimarmiami
The company total isn't technically a running total; however when I add it to a field within my location group it acts like one so that each row is added to the previous row. This is what I meant by it throwing off the numbers when I try to use it in my location group section. Thank you — Kdunc2015
Is there a way to share a value between reports and where the value would not be effected by which group it was in? — Kdunc2015

cojimarmiami cojimarmiami · Accepted Answer · 2016-01-22T12:35:25

your best option is creating a subreport on the report header to calculate only your total revenue and then using it on your main report through a shared variable.

Crystal Report XI: calculate subtotal % of total

2 Answers