I am having a heck of a time getting my cumulative percentage per month to show on a chart. I have my running totals calculating perfectly in the report by month.
I have 2 groups A & B. I have a running total that resets at the change of Group A. Group B is by month and I want my totals to grow for each month based on each previous. There are two running totals. The next step is to calculate a percentage for each month based on the final running totals of these two numbers for that month. The calculation works fine but it is not an option to include in my chart.
Any ideas??