Formula 3 - Salves v Target cumulative % =[Ex-Factory Actual C]/[Ex-Factory LBE C]
These work perfectly in the pivot table. However, when I put these in to a chart (where 1 & 2 are bars and 3 is a line) and have 'Full Accumulation' on 1&2, 1&2 work fine but 3 does not. 3 does not do a cumulative Sales v Target (SvT), just monthly SvT. If I add Full Accumulation to 3 it simply adds together the SvT figures for each month cumulatively (so we end up with 300% after 3 months for example).
Essentially what I'm looking for is the SvT line to cumulatively add sales and target by month (flexible dependent on time period selected) and divide sales by target for the SvT in a line on the graph and for this to show for every month selected.
I think it would be better to accumulate using RangeSum for the third expression.. also are you using this in a straight table or pivot table? What is Before even doing here? It doesn't even work in a straight table? If you are not using straight table, then where are you getting the option to do full accumulation in pivot table?