I need to show a cumulative total based on multiplied values from two fields in a bar graph.
I need to use set analysis to multiply each month's census * credits to come up with the cumulative target for each month.
Unfortunately if I tell it to give me the months less than this month (Jan-July), sum (Census) * sum(Credits) it multiplies 1050 * 28 (29400) where as I need it to multiply and add each row independently to give me 4200.