Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Formula for elapsed time + grand total | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
Custom formula to show each item as percentage of grand total? | Charts and Charting in Excel |