Pivot Table and Running Totals

[johnca]

I have a pivot table of Ship quantity by Year-Month and Failure quantity by TTF in Months (Time To Failure). This is the first pivot table below, and is in Qlikview. I also added a Ship Qty accumulate column I need to use in my reliability calculation. I don't know how to get that number in the denominator of my calculation; Sum (1 Month To Fail) / Sum (Ship Cumu Qty)

Note the row of data between the two pivot tables...this is what I need to find out, and is equal to the percent of all 1 Month to Fail units divided by the corresponding ship months cum qty. For example; 73 (total of 1 Month to Fail units) would divide by Sum of Ship Qty Year-Mo 2009-09 thru 2010-08 (or Ship Cumu at 2010-08), 230 (total of 2 Months to Fail units) would divide by Sum of Ship Qty Year-Mo 2009-09 thru 2010-07 (or Ship Cumu at 2010-07), 201 (total of 3 Months to Fail units) would divide by Sum of Ship Qty Year-Mo 2009-09 thru 2010-06 (or Ship Cumu at 2010-06), …etc. This is what I can't seem to figure out.

The bottom pivot table is then each month of returns divided by each month of shipments, and the conditional formatting (END GOAL) is based on its relationship to the row of data, that I can't figure out.