<title>Excel Jeanie HTML</title>Here is a sample A1:B13 is the data and from column D to H is the pivot table. How will i show the total number of blank cells in "(blank)" column in the pivot table?
Thanks!
<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Century Gothic,Arial; font-size: 10pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 146px;"> <col style="width: 64px;"> <col style="width: 64px;"> <col style="width: 95px;"> <col style="width: 120px;"> <col style="width: 57px;"> <col style="width: 55px;"> <col style="width: 84px;"></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> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td> <td>Group Name</td> <td>Paid</td> <td> </td> <td>Count of Paid</td> <td>Column Labels</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;">2</td> <td>TEAM A</td> <td>YES</td> <td> </td> <td>Row Labels</td> <td>NO</td> <td>YES</td> <td>(blank)</td> <td>Grand Total</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td>TEAM B</td> <td> </td> <td> </td> <td style="text-align: left;">TEAM A</td> <td style="text-align: right;">1</td> <td style="text-align: right;">3</td> <td style="background-color: rgb(255, 255, 204);"> </td> <td style="text-align: right;">4</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td>TEAM C</td> <td> </td> <td> </td> <td style="text-align: left;">TEAM B</td> <td> </td> <td> </td> <td style="background-color: rgb(255, 255, 204);"> </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>TEAM D</td> <td> </td> <td> </td> <td style="text-align: left;">TEAM C</td> <td> </td> <td> </td> <td style="background-color: rgb(255, 255, 204);"> </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>TEAM E</td> <td>YES</td> <td> </td> <td style="text-align: left;">TEAM D</td> <td style="text-align: right;">1</td> <td> </td> <td style="background-color: rgb(255, 255, 204);"> </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>TEAM A</td> <td>YES</td> <td> </td> <td style="text-align: left;">TEAM E</td> <td> </td> <td style="text-align: right;">1</td> <td style="background-color: rgb(255, 255, 204);"> </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>TEAM A</td> <td>YES</td> <td> </td> <td style="text-align: left;">Grand Total</td> <td style="text-align: right;">2</td> <td style="text-align: right;">4</td> <td style="background-color: rgb(255, 255, 204);"> </td> <td style="text-align: right;">6</td></tr> <tr style="height: 18px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td> <td>TEAM A</td> <td> </td> <td> </td> <td> </td> <td> </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;">10</td> <td>TEAM A</td> <td> </td> <td> </td> <td> </td> <td> </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;">11</td> <td>TEAM B</td> <td> </td> <td> </td> <td> </td> <td> </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;">12</td> <td>TEAM D</td> <td>NO</td> <td> </td> <td> </td> <td> </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;">13</td> <td>TEAM A</td> <td>NO</td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td></tr></tbody></table>