I Need to get the calculation that is in a Data sheet column to work in the Pivot Table - I've tried several different ways and it only sums it doesn't perform the SUMPRODUCT like it does in the other table. =SUMPRODUCT(G6:G7,F6:F7)/SUM(F6:F7) is the calculation used in the spreadsheet but when I try running it in a calculated field within the Pivot table it doesn't work. Here is what I have in the Pivot table but it just sums and doesn't do the SumProduct =SUMPRODUCT(CapRate,MemberMonths)/SUM(MemberMonths)