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>,
Try using: ON REGION SUMMARIZE
Instead of: ON REGION SUBTOTAL
Let me know if that works.
WebFocus 8.201M, Windows, App Studio
Yes that worked. Thank you!
|Powered by Social Strata|