Assuming your data is in A2:A10 and B2:B10...

Grand Total would be equal to:
=SUMPRODUCT(($A$2:$A$10)*($B$2:$B$10))

Hope this helps.
--
John C


"Dan K" wrote:

I had created a formula of (column 1) * (column 2) and the results are
correct. The problem that I am having is that the grand total does not sum
the results. The grand total takes the (sum of colum 1 * the sum of column 2)

Is there a way to sum the formula total in the pivot table?