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>

 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

BrianExcel

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

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,588
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top