Pivot Table Sum

sstyre

New Member
Joined
May 28, 2014
Messages
13
So, I have a table I want to use to display total sales, pulling from a pivot table data tab on my sheet. However, I can't get the proper formulation to do the calculations across the cells for the pivot table to add up correctly unfortunately. Anyone able to help out with some advise here?

Thanks in advance!

Excel 2010
ABC
3Client NameContract PeriodTotal Sales
4Customer AJan - Dec, 2014
5Customer BFeb 2014 - Jan, 2015
6Customer CJuly, 2014 - June 2015
7Customer DJan - Dec, 2014
8Customer EApri, 2014 - March, 2015
9Customer FAug, 2014 - Aug, 2015
10Customer GJan - Dec, 2014
11Customer HFeb 2014 - Jan, 2015
12Customer IJuly, 2014 - June 2015
13Customer JJan - Dec, 2014
14Customer KApri, 2014 - March, 2015
15Customer LAug, 2014 - Aug, 2015
16Customer MJan - Dec, 2014
17Customer NFeb 2014 - Jan, 2015
18Customer OJuly, 2014 - June 2015
19Customer PJan - Dec, 2014
20

<tbody>
</tbody>



Excel 2010
AEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBA
2Sum of Total SellColumn Labels
3Row LabelsApr/2013Apr/2014Aug/2013Aug/2014Dec/2013Feb/2013Feb/2014Jan/2013Jan/2014Jul/2013Jul/2014Jun/2013Jun/2014Mar/2013Mar/2014May/2013May/2014Nov/2013Oct/2013Sep/2013Sep/2014Grand Total
4Customer A-$137.42$20,663.92-$6,495.40-$14,185.36$6,008.43-$8,023.18-$8.80-$7,582.70-$14,600.40-$2,141.80-$41,839.08-$5,556.84$15,531.33-$12,017.20$68.90-$38.85-$3,788.69-$3,400.44-$7,040.94-$84,584.52
5Customer B$4,900.91$8,136.50$13,037.41
6Customer C$0.00$0.00
7Customer D$859.41$190.98$1,050.39
8Customer E$55,111.65$37.95$7,880.70$63,030.30
9Customer F$0.00$0.00
10Customer G$6,071.16$1,427.60$3,547.74-$1,212.70-$25,038.12-$15,204.32
11Customer H$1,207.49$1,207.49
12Customer I$4,124.91$4,124.91
13Customer J-$18,818.80$7,929.68-$5,452.80$10,144.44$18,826.00$12,628.52
14Customer K$16,646.48$16,646.48
15Customer L-$991.10$991.10$11,445.82$11,445.82
16Customer M$67.07$67.07
17Customer N$30,635.81$1,204.71$0.00$0.00$31,840.52
18Customer O$46,576.32$46,576.32
19Customer P$155.77$2,508.08$2,663.85
20Grand Total-$137.42$20,663.92-$6,495.40-$14,185.36$28,665.82-$8,023.18$124,858.12-$4,470.50$10,144.44-$7,582.70-$14,600.40-$2,141.80-$41,839.08-$5,556.84$19,184.09-$12,017.20$40,724.29-$8,430.49-$3,788.69-$3,400.44-$7,040.94$104,530.24

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Not really understanding what the issue is. Is it that you wrote your formula, but when you drag the formula across different cells, it copies the same formula and cell references instead of the next cell?
 
Upvote 0
Not really understanding what the issue is. Is it that you wrote your formula, but when you drag the formula across different cells, it copies the same formula and cell references instead of the next cell?

Nope, it's getting the original formula to work, using GETPIVOTDATA. Just having a hard time wrapping my head fully around it when it's involving more than 12 months of data to do a count that way for each month appropriately.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top