Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table conundrum
OK, I have a pivot table with one field in the row section, no fields in the column section, and 6 fields in the data section. Of these 6 fields in the data section, 5 are "count" and one is "Sum". Subtotals are set to none on the row field. When the pivot is created I get three elements in the row. Here is the issue....... When I double click into the data section for the second or third element in the row I get what is expected, i.e. if the count in one of the data fields is 7, when I double click on the 7 I get a new sheet with those 7 records. The same is true for the for all data fields on the second or third row element. When I do the same for the first row element, I get all the records in the data set.....i.e. if the count of a particular data field is 10, when I double click it I get all 3000 records from the data set. What setting am I missing? Thanks. -- Flamikey ------------------------------------------------------------------------ Flamikey's Profile: http://www.excelforum.com/member.php...fo&userid=4612 View this thread: http://www.excelforum.com/showthread...hreadid=377197 |
#2
|
|||
|
|||
How did this get buried so quick??? I posted and right away it was 4 pages down. very wierd. -- Flamikey ------------------------------------------------------------------------ Flamikey's Profile: http://www.excelforum.com/member.php...fo&userid=4612 View this thread: http://www.excelforum.com/showthread...hreadid=377197 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |