Grand total sum of formula
Currently the Pivot table is doing that and I do not wat that
example:
item Qty Price Formula
x 10 5 50.00
y 5 10 50.00
z 1 50 50.00
GrdT 16 65 1040.00 <-- Currently shown in pivot table
GrdT 16 65 150.00 <-- This is what I want
Hope that helps
"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?
|