Hey,
I'm using a pivot table for a production report. I want to subtotal the rows but when viewing the % of total I dont want the subtotals to be counted. Its counting each subtotal as a percentage of the whole...somenone help!
Thank you!!
<TABLE style="WIDTH: 502pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=668><COLGROUP><COL style="WIDTH: 130pt; mso-width-source: userset; mso-width-alt: 6326" width=173><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 237pt; mso-width-source: userset; mso-width-alt: 11556" width=316><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 130pt; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20 width=173>ChgCat</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 width=62>CPTCode</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 237pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 width=316>ChgCodeDesc</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 37pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 width=49>Units</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=68>% of Total</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>Est. Patient E & M</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99211</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>17</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>2.72%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99212</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>15</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>2.40%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99213</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>367</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>58.63%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99214</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>150</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>23.96%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99215</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>2</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.32%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>Est. Patient E & M Total</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>551</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>88.02%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>New Patient E & M</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99202</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, New</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>1</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.16%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99203</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, New</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>10</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>1.60%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99204</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, New</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>7</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>1.12%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>New Patient E & M Total</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>18</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>2.88%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>Preventive Medicine</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99383</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, New, Age 5-11</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>2</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.32%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99385</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, New, Age 18-39</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>5</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.80%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99386</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, New, Age 40-64</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>2</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.32%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99392</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, Est, Age 1-4</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>1</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.16%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99393</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, Est, Age 5-11</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>1</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.16%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99395</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, Est, Age 18-39</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>9</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>1.44%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99396</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, Est, Age 40-64</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>28</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>4.47%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99397</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Periodic Preventive Med Est Patient Age 65yrs&></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>9</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>1.44%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>Preventive Medicine Total</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>57</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>9.11%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl68 height=20>Grand Total</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl68 align=right>626</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right>100.00%</TD></TR></TBODY></TABLE>
<!-- / message -->
I'm using a pivot table for a production report. I want to subtotal the rows but when viewing the % of total I dont want the subtotals to be counted. Its counting each subtotal as a percentage of the whole...somenone help!
Thank you!!
<TABLE style="WIDTH: 502pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=668><COLGROUP><COL style="WIDTH: 130pt; mso-width-source: userset; mso-width-alt: 6326" width=173><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 237pt; mso-width-source: userset; mso-width-alt: 11556" width=316><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 130pt; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20 width=173>ChgCat</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 width=62>CPTCode</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 237pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 width=316>ChgCodeDesc</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 37pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 width=49>Units</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl65 width=68>% of Total</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>Est. Patient E & M</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99211</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>17</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>2.72%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99212</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>15</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>2.40%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99213</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>367</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>58.63%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99214</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>150</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>23.96%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99215</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, Est</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>2</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.32%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>Est. Patient E & M Total</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>551</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>88.02%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>New Patient E & M</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99202</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, New</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>1</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.16%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99203</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, New</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>10</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>1.60%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99204</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Office/Outpatient Visit, New</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>7</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>1.12%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>New Patient E & M Total</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>18</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>2.88%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>Preventive Medicine</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99383</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, New, Age 5-11</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>2</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.32%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99385</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, New, Age 18-39</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>5</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.80%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99386</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, New, Age 40-64</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>2</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.32%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99392</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, Est, Age 1-4</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>1</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.16%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99393</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, Est, Age 5-11</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>1</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>0.16%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99395</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, Est, Age 18-39</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>9</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>1.44%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99396</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Prev Visit, Est, Age 40-64</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>28</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>4.47%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8" class=xl67 height=20></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>99397</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63>Periodic Preventive Med Est Patient Age 65yrs&></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>9</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>1.44%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 height=20>Preventive Medicine Total</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl64></TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl63 align=right>57</TD><TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 align=right>9.11%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl68 height=20>Grand Total</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid" class=xl68 align=right>626</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-LEFT-COLOR: #ece9d8; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl70 align=right>100.00%</TD></TR></TBODY></TABLE>
<!-- / message -->
