Grand total sum of formula
 

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?

Grand total sum of formula
 

Dan,

I'm not sure I understand this but maybe your using something like

=SUM(A1:A40)*SUM(B1:B40)

and what you should be using is

=SUMPRODUCT(A1:A40*B1:B40)

Mike

"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?

Grand total sum of formula
 

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?

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?

Grand total sum of formula
 

On Oct 7, 10:27*am, Dan K wrote:
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?- Hide quoted text -

- Show quoted text -

Just add a sum on the C column that will always show the grand total
of all lines.
The total unit price is not accurate because you are selling different
products with different prices so I don’t see how this would apply?
I mean if you go the the supermarket and you buy 32 different products
with different prices there is not going to be a total unit price.

FG

Grand total sum of formula
 

On Oct 7, 11:56*am, "F.G." wrote:
On Oct 7, 10:27*am, Dan K wrote:





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?- Hide quoted text -

- Show quoted text -

Just add a sum on the C column that will always show the grand total
of all lines.
The total unit price is not accurate because you are selling different
products with different prices so I don’t see how this would apply?
I mean if you go the the supermarket and you buy 32 different products
with different prices there is not going to be a total unit price.

FG- Hide quoted text -

- Show quoted text -

I meant D column instead of C sorry.

Grand total sum of formula
 

The problem is that this is a Pivot table and the size changes daily.

"F.G." wrote:

On Oct 7, 10:27 am, Dan K wrote:
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?- Hide quoted text -

- Show quoted text -

Just add a sum on the C column that will always show the grand total
of all lines.
The total unit price is not accurate because you are selling different
products with different prices so I dont see how this would apply?
I mean if you go the the supermarket and you buy 32 different products
with different prices there is not going to be a total unit price.

FG