BrianGGG
Board Regular
- Joined
- Mar 5, 2016
- Messages
- 62
I can't tell whether this is the expected behavior or not, but I am getting more data than I would have expected when I do "show details" or Drill Down from within a Pivot Table.
Here is a simple dataset:
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Here is a pivot table of that data with two values:
<tbody>
</tbody>
If I double click on the "3" value for January 1, here's where I get too much data:
<tbody>
</tbody>
Shouldn't this drill down just return the three rows that make up the "3" value in the table rather than all 5 values for Jan 1?
Thanks
BrianGGG
Here is a simple dataset:
A | B | C | |
---|---|---|---|
1 | Date | Val 1 | Val 2 |
2 | 01-Jan | 1 | |
3 | 01-Jan | 1 | |
4 | 01-Jan | 0 | 1 |
5 | 01-Jan | 0 | 1 |
6 | 01-Jan | 1 | |
7 | 02-Jan | 0 | 1 |
8 | 02-Jan | 1 | |
9 | 02-Jan | 0 | |
10 | 02-Jan | 1 |
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Test
Here is a pivot table of that data with two values:
I | J | K | |
---|---|---|---|
7 | Row Labels | Sum of Val 1 | Count of Val 2 |
8 | 01-Jan | 3 | 2 |
9 | 02-Jan | 2 | 1 |
10 | Grand Total | 5 | 3 |
<tbody>
</tbody>
Test
If I double click on the "3" value for January 1, here's where I get too much data:
A | B | C | |
---|---|---|---|
1 | Date | Val 1 | Val 2 |
2 | 01/01/19 | 1 | |
3 | 01/01/19 | 1 | |
4 | 01/01/19 | 0 | 1 |
5 | 01/01/19 | 0 | 1 |
6 | 01/01/19 | 1 |
<tbody>
</tbody>
Sheet8
Shouldn't this drill down just return the three rows that make up the "3" value in the table rather than all 5 values for Jan 1?
Thanks
BrianGGG