How to make report page pivot tabs to have same row as master pivot

E

excelsishya

Board Regular
Joined
Jul 25, 2010
Messages
107
Hi all,

Is it possible to make pivot tabs created by show report page filter to have same row as master pivot.I am using excel 2007

Thanks all

see sample below TAB1(DivisionA)
DivisionA

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 64px;"> <col style="width: 64px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>C</td> <td>D</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td>Product</td> <td>SALES</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td>A</td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td>B</td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td>C</td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">8</td> <td>D</td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td> <td>E</td> <td style="text-align: right;">1</td></tr></tbody></table>
tab2(DivisionB)
DivisionB

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 64px;"> <col style="width: 64px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>E</td> <td>F</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td>Product</td> <td>SALES</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>A</td> <td style="text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td>B</td> <td style="text-align: right;">2</td></tr></tbody></table>
Tab3

DivisionC

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 64px;"> <col style="width: 64px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>B</td> <td>C</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>Product</td> <td>SALES</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td>A</td> <td style="text-align: right;">3</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td>B</td> <td style="text-align: right;">3</td></tr></tbody></table>

Database setup to run pivot

database

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 64px;"> <col style="width: 64px;"> <col style="width: 64px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>C</td> <td>D</td> <td>E</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td style="font-weight: bold;">Product</td> <td style="font-weight: bold;">SALES</td> <td style="font-weight: bold;">DIVISION</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td>A</td> <td style="text-align: right;">1</td> <td>DivisionA</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td>B</td> <td style="text-align: right;">1</td> <td>DivisionA</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td>C</td> <td style="text-align: right;">1</td> <td>DivisionA</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td>D</td> <td style="text-align: right;">1</td> <td>DivisionA</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">8</td> <td>E</td> <td style="text-align: right;">1</td> <td>DivisionA</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td> <td>A</td> <td style="text-align: right;">2</td> <td>DivisionB</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">10</td> <td>B</td> <td style="text-align: right;">2</td> <td>DivisionB</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">11</td> <td>A</td> <td style="text-align: right;">3</td> <td>DivisionC</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">12</td> <td>B</td> <td style="text-align: right;">3</td> <td>DivisionC</td></tr></tbody></table>
Master pivot

PIVOT

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 92px;"> <col style="width: 89px;"> <col style="width: 64px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td> <td>DIVISION</td> <td>(All)</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>Row Labels</td> <td>Sum of SALES</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td style="text-align: left;">A</td> <td style="text-align: right;">6</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td style="text-align: left;">B</td> <td style="text-align: right;">6</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td style="text-align: left;">C</td> <td style="text-align: right;">1</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td style="text-align: left;">D</td> <td style="text-align: right;">1</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">8</td> <td style="text-align: left;">E</td> <td style="text-align: right;">1</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td> <td style="text-align: left;">Grand Total</td> <td style="text-align: right;">15</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">10</td> <td>
</td> <td>
</td></tr></tbody></table> (please ignore column c it just captured by jeanie it has no role

After show report page filter
3 pivot tabs created are

1 DivisionA (2)

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 92px;"> <col style="width: 89px;"> <col style="width: 64px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td> <td>DIVISION</td> <td>DivisionA</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td>
</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>Row Labels</td> <td>Sum of SALES</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td style="text-align: left;">A</td> <td style="text-align: right;">1</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td style="text-align: left;">B</td> <td style="text-align: right;">1</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td style="text-align: left;">C</td> <td style="text-align: right;">1</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td style="text-align: left;">D</td> <td style="text-align: right;">1</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">8</td> <td style="text-align: left;">E</td> <td style="text-align: right;">1</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td> <td style="text-align: left;">Grand Total</td> <td style="text-align: right;">5</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">10</td> <td>
</td> <td>
</td> <td>
</td></tr></tbody></table>
2 DivisionB (2) . Desired output is these 2 pivot to display A ,B, C D, E as found in master pivot but C,D, E, with zero or blank as it has no value .

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 92px;"> <col style="width: 89px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>A</td> <td>B</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td> <td>DIVISION</td> <td>DivisionB</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>Row Labels</td> <td>Sum of SALES</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td style="text-align: left;">A</td> <td style="text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td style="text-align: left;">B</td> <td style="text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td style="text-align: left;">Grand Total</td> <td style="text-align: right;">4</td></tr></tbody></table>3 DivisionC (2)

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 92px;"> <col style="width: 89px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>A</td> <td>B</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td> <td>DIVISION</td> <td>DivisionC</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td>
</td> <td>
</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>Row Labels</td> <td>Sum of SALES</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td style="text-align: left;">A</td> <td style="text-align: right;">3</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td style="text-align: left;">B</td> <td style="text-align: right;">3</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td style="text-align: left;">Grand Total</td> <td style="text-align: right;">6

</td></tr></tbody></table>
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Commendations on a well-presented post!


Creating placeholders in the source data accomplishes this.
below are two layouts of the source data.
I'll throw the cautionary beware of Pivot:Counts with this method.

{tried running a union against two tables as well as multi-consolidation range through wizard (ALT D P) and couldn't get the pivot to come to agreement with my expectations :(}


Sales Data


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=0 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px"><COL style="WIDTH: 78px"><COL style="WIDTH: 67px"><COL style="WIDTH: 100px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"><TD> </TD><TD style="BORDER-BOTTOM: #f0f0f0 3px double; BORDER-LEFT: #f0f0f0 3px double; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">A</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px double; BORDER-LEFT: #f0f0f0 3px double; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">B</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px double; BORDER-LEFT: #f0f0f0 3px double; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">C</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">5</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #3867a6 2px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">Product</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">SALES</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">DIVISION</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">6</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">7</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">2</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">8</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">3</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">9</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">10</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">2</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">11</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">3</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">12</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">C</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">13</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">C</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">14</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">C</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">15</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">D</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">16</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">D</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">17</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">D</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">18</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">E</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">19</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">E</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">20</TD><TD style="BORDER-BOTTOM-COLOR: #000000; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">E</TD><TD style="BORDER-BOTTOM-COLOR: #000000; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; BORDER-BOTTOM-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM-COLOR: #3867a6; BORDER-TOP-COLOR: #3867a6; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 2px; BORDER-BOTTOM-WIDTH: 2px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #3867a6; BORDER-LEFT-WIDTH: 2px; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR></TBODY></TABLE>


Version 2 Source Data
placeholders on top, actual data under

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=0 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px"><COL style="WIDTH: 78px"><COL style="WIDTH: 67px"><COL style="WIDTH: 105px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"><TD> </TD><TD style="BORDER-BOTTOM: #f0f0f0 3px double; BORDER-LEFT: #f0f0f0 3px double; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">A</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px double; BORDER-LEFT: #f0f0f0 3px double; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">B</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px double; BORDER-LEFT: #f0f0f0 3px double; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">C</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">5</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #3867a6 2px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">Product</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">SALES</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 1px solid">DIVISION</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">6</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">7</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">8</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">9</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">10</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">11</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">12</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">C</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">13</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">C</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">14</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">C</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">15</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">D</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">16</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">D</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">17</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">D</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">18</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">E</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">19</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">E</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">20</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">E</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">0</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">21</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">22</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">2</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">23</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">A</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">3</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">24</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">25</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">2</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">26</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">B</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">3</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionC</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">27</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">C</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">28</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">D</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">29</TD><TD style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 1px solid">E</TD><TD style="BORDER-BOTTOM: #000000 1px solid; TEXT-ALIGN: right; BORDER-TOP-COLOR: #000000; FONT-FAMILY: Verdana; BORDER-TOP-WIDTH: 1px; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #000000; BORDER-LEFT-WIDTH: 1px; BORDER-RIGHT: #000000 1px solid">1</TD><TD style="BORDER-BOTTOM: #000000 1px solid; FONT-FAMILY: Verdana; COLOR: #0000ff; FONT-SIZE: 10pt; BORDER-RIGHT: #3867a6 2px solid">DivisionA</TD></TR></TBODY></TABLE>



Either Results in:
DivisionB


<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=0 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px"><COL style="WIDTH: 92px"><COL style="WIDTH: 89px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"><TD> </TD><TD style="BORDER-BOTTOM: #f0f0f0 3px double; BORDER-LEFT: #f0f0f0 3px double; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">A</TD><TD style="BORDER-BOTTOM: #f0f0f0 3px double; BORDER-LEFT: #f0f0f0 3px double; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">B</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">1</TD><TD>DIVISION</TD><TD>DivisionB</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">2</TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">3</TD><TD>Row Labels</TD><TD>Sum of SALES</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">4</TD><TD style="TEXT-ALIGN: left">A</TD><TD style="TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">5</TD><TD style="TEXT-ALIGN: left">B</TD><TD style="TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">6</TD><TD style="TEXT-ALIGN: left">C</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">7</TD><TD style="TEXT-ALIGN: left">D</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">8</TD><TD style="TEXT-ALIGN: left">E</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="BORDER-BOTTOM: #f0f0f0 3px double; TEXT-ALIGN: center; BORDER-LEFT: #f0f0f0 3px double; BACKGROUND-COLOR: #cacaca; BORDER-TOP: #f0f0f0 3px double; BORDER-RIGHT: #f0f0f0 3px double">9</TD><TD style="TEXT-ALIGN: left">Grand Total</TD><TD style="TEXT-ALIGN: right">4</TD></TR></TBODY></TABLE>
 
Upvote 0
Excelsishya,

Or try this:

In the PivotTable Master, give a right click over any field Product (row area), choose Field settings, enable the Layout & print tab, enable the option Show items with no data and click OK.

Markmzz
 
Upvote 0
Tweedle & markmzz Thanks for the solution.Both of them work fine.

Nice to have multiple solution.

Markmzz never realized just adjustment in setting would do this realy cool tip.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
583
mumps
mumps
E
  • Question Question
Adding a custom message.
Replies
1
Views
666
Micron
M
k3yn0t3
  • Solved
INDEX(MATCH()) pulling wrong row data & Macro to duplicate sheets with formulas
Replies
4
Views
570
Alex Blakenburg
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C

Forum statistics

Threads
1,224,600
Messages
6,179,833
Members
452,947
Latest member
Gerry_F

Share this page

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