I have a procedure where I have two calculated fields summing sales dollars for 2013 and 2014 by customer. I have those two fields on my report and have calculated a percent change year over year by customer. I have a subtotal on customer region that totals the sales dollars by region for groups of customers. How can I calculate the percent change year over year on my region subtotal? It is summing the percent changes for the region on the subtotal now. Looks like this:
2013 2014 % Change Customer A 200 250 25% Customer B 500 400 -20% Subtotal 700 650 -5% should be -7.1%
It is summing the % Change percentages to get the -5%. How can I calculate the percent change for the Subtotal?This message has been edited. Last edited by: <Kathryn Henning>,