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
<tbody>
</tbody>
Excel 2010
<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>
Thanks in advance!
Excel 2010
A | B | C | |
---|---|---|---|
3 | Client Name | Contract Period | Total Sales |
4 | Customer A | Jan - Dec, 2014 | |
5 | Customer B | Feb 2014 - Jan, 2015 | |
6 | Customer C | July, 2014 - June 2015 | |
7 | Customer D | Jan - Dec, 2014 | |
8 | Customer E | Apri, 2014 - March, 2015 | |
9 | Customer F | Aug, 2014 - Aug, 2015 | |
10 | Customer G | Jan - Dec, 2014 | |
11 | Customer H | Feb 2014 - Jan, 2015 | |
12 | Customer I | July, 2014 - June 2015 | |
13 | Customer J | Jan - Dec, 2014 | |
14 | Customer K | Apri, 2014 - March, 2015 | |
15 | Customer L | Aug, 2014 - Aug, 2015 | |
16 | Customer M | Jan - Dec, 2014 | |
17 | Customer N | Feb 2014 - Jan, 2015 | |
18 | Customer O | July, 2014 - June 2015 | |
19 | Customer P | Jan - Dec, 2014 | |
20 |
<tbody>
</tbody>
Excel 2010
AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ | BA | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Sum of Total Sell | Column Labels | |||||||||||||||||||||
3 | Row Labels | Apr/2013 | Apr/2014 | Aug/2013 | Aug/2014 | Dec/2013 | Feb/2013 | Feb/2014 | Jan/2013 | Jan/2014 | Jul/2013 | Jul/2014 | Jun/2013 | Jun/2014 | Mar/2013 | Mar/2014 | May/2013 | May/2014 | Nov/2013 | Oct/2013 | Sep/2013 | Sep/2014 | Grand Total |
4 | Customer 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 | ||
5 | Customer B | $4,900.91 | $8,136.50 | $13,037.41 | |||||||||||||||||||
6 | Customer C | $0.00 | $0.00 | ||||||||||||||||||||
7 | Customer D | $859.41 | $190.98 | $1,050.39 | |||||||||||||||||||
8 | Customer E | $55,111.65 | $37.95 | $7,880.70 | $63,030.30 | ||||||||||||||||||
9 | Customer F | $0.00 | $0.00 | ||||||||||||||||||||
10 | Customer G | $6,071.16 | $1,427.60 | $3,547.74 | -$1,212.70 | -$25,038.12 | -$15,204.32 | ||||||||||||||||
11 | Customer H | $1,207.49 | $1,207.49 | ||||||||||||||||||||
12 | Customer I | $4,124.91 | $4,124.91 | ||||||||||||||||||||
13 | Customer J | -$18,818.80 | $7,929.68 | -$5,452.80 | $10,144.44 | $18,826.00 | $12,628.52 | ||||||||||||||||
14 | Customer K | $16,646.48 | $16,646.48 | ||||||||||||||||||||
15 | Customer L | -$991.10 | $991.10 | $11,445.82 | $11,445.82 | ||||||||||||||||||
16 | Customer M | $67.07 | $67.07 | ||||||||||||||||||||
17 | Customer N | $30,635.81 | $1,204.71 | $0.00 | $0.00 | $31,840.52 | |||||||||||||||||
18 | Customer O | $46,576.32 | $46,576.32 | ||||||||||||||||||||
19 | Customer P | $155.77 | $2,508.08 | $2,663.85 | |||||||||||||||||||
20 | Grand 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>