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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

BrianExcel

Well-known Member
Joined
Apr 21, 2010
Messages
969
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?
 

sstyre

New Member
Joined
May 28, 2014
Messages
13
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,487
Messages
5,831,980
Members
430,100
Latest member
namhnz

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
Top