scareycarey
New Member
- Joined
- Apr 1, 2016
- Messages
- 10
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
<tbody>
</tbody>
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
Bottom 5 | |
Row Labels | Sum of *** |
A | 21 |
D | 34 |
E | 12 |
F | 0 |
H | 0 |
I | 34 |
<tbody>
</tbody>
Last edited: