Can I make a calculated field which is the ratio of two running totals, as opposed to what appears to be happening whereby Excel is using the sum of the field rather than running total of sum of field?
My source data shows some data including variations in total incurred cost; I'm displaying the variations in my pivot table as a running total -- each row (grouped by quarters [blocks of 3 months]) sums the cost variations and adds to the previous quarter's total.
I'm interested in getting the ratio of incurred cost (total for the whole of time up to the end of the quarter, not just that quarter's results) to the total sum of insurance premiums paid. I've tried making a calculated field which divides the relevant fields but it calculates based on the sum rather than running total of sums.
Can I use some function in the calculated field formula to get the running total? I tried using =GETPIVOTDATA() but I get the error "References, names and arrays are not supported in PivotTable formulas".
