Pivot Table problem

[scareycarey]

Hi All
I am having a problem with a pivot table which I need help with please. From the data table below I want to get the bootom 5 values but exclude the blank cells from the cvount in the pivot table.
The pivot table below shows them as 0 and includes them in the bottom 5.

Data Table
TANO NAME SUM OF

1 A 21
2 B 45
3 C 65
4 D 34
5 E 12
6 F
7 G 89
8 H
9 I 34
10 J 36



Pivot Table
[TABLE="width: 167"]
<tbody>[TR]
[TD] Bottom 5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD]Sum of ***[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]I[/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]