| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying pivot cell underlying data
One of the really neat features of a pivot is that by clicking on a pivot
cell, it displays a new worksheet of the underlying data that makes up the cell value.... Unfortunately, this is having unpredictable results - some times many more rows are returned than the value in the pivot cell. Can anyone tell me why this is - or am I doing something dumb...? -- Mike Watkins |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
The list that's created should only include the records summarized in
the cell that you double-clicked. Can you give an example of the results that you're seeing? watkincm wrote: One of the really neat features of a pivot is that by clicking on a pivot cell, it displays a new worksheet of the underlying data that makes up the cell value.... Unfortunately, this is having unpredictable results - some times many more rows are returned than the value in the pivot cell. Can anyone tell me why this is - or am I doing something dumb...? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
Debra,
This is a mock-up representation of the pivot result... C D E F G 18 Geo 1 4 30 79 193 314 19 Geo 2 7 60 140 272 428 20 Geo 3 2 25 165 140 280 As an example, if I click on cell C19, while the displayed value is 7, 18 rows are produced - it's the same 18 for each cell in that column. In col. D, it displays 627 rows for each cell in that pivot col... Is this any help? -- Mike Watkins "Debra Dalgleish" wrote: The list that's created should only include the records summarized in the cell that you double-clicked. Can you give an example of the results that you're seeing? watkincm wrote: One of the really neat features of a pivot is that by clicking on a pivot cell, it displays a new worksheet of the underlying data that makes up the cell value.... Unfortunately, this is having unpredictable results - some times many more rows are returned than the value in the pivot cell. Can anyone tell me why this is - or am I doing something dumb...? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
It's hard to tell what the data mean. If the 7 is a sum, it could be the
total of 18 rows that contain positive and negative values in the field in column C. But if Geo 1, Geo 2 and Geo 3 are different items in a field, double-clicking on cell C18 should give you records for Geo 1. They should be different than what you'd get by double-clicking on C19. watkincm wrote: Debra, This is a mock-up representation of the pivot result... C D E F G 18 Geo 1 4 30 79 193 314 19 Geo 2 7 60 140 272 428 20 Geo 3 2 25 165 140 280 As an example, if I click on cell C19, while the displayed value is 7, 18 rows are produced - it's the same 18 for each cell in that column. In col. D, it displays 627 rows for each cell in that pivot col... Is this any help? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
The first and third values in the column are "Count", while the middle value
is "Count Nums". It turns out that the rows being returned tie to another, initial pivot in the workbook (there are 3). The initial pivot displays rows correctly. The other two pivot tables both exhibit the same problem and are both "based on the same data" as the first - to save space! Is this a characteristic of "cloned" tables? If I wish these tables to display correctly, should I create a new workbook each time...? -- Mike Watkins "Debra Dalgleish" wrote: It's hard to tell what the data mean. If the 7 is a sum, it could be the total of 18 rows that contain positive and negative values in the field in column C. But if Geo 1, Geo 2 and Geo 3 are different items in a field, double-clicking on cell C18 should give you records for Geo 1. They should be different than what you'd get by double-clicking on C19. watkincm wrote: Debra, This is a mock-up representation of the pivot result... C D E F G 18 Geo 1 4 30 79 193 314 19 Geo 2 7 60 140 272 428 20 Geo 3 2 25 165 140 280 As an example, if I click on cell C19, while the displayed value is 7, 18 rows are produced - it's the same 18 for each cell in that column. In col. D, it displays 627 rows for each cell in that pivot col... Is this any help? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
I've never seen that behaviour, even in a pivot table that's based on
another pivot table. What version of Excel are you using? watkincm wrote: The first and third values in the column are "Count", while the middle value is "Count Nums". It turns out that the rows being returned tie to another, initial pivot in the workbook (there are 3). The initial pivot displays rows correctly. The other two pivot tables both exhibit the same problem and are both "based on the same data" as the first - to save space! Is this a characteristic of "cloned" tables? If I wish these tables to display correctly, should I create a new workbook each time...? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
I have a related question. Is there a way to have the underlying data go into
just one new worksheet when you double-click/drill-down on a cell? Right now Excel adds a new worksheet for every cell you drill-down on. Thanks! Cynthia "watkincm" wrote: One of the really neat features of a pivot is that by clicking on a pivot cell, it displays a new worksheet of the underlying data that makes up the cell value.... Unfortunately, this is having unpredictable results - some times many more rows are returned than the value in the pivot cell. Can anyone tell me why this is - or am I doing something dumb...? -- Mike Watkins |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
No, you can't select a destination for the data that's created. Excel
adds a sheet, and places the data there. lovemuch wrote: I have a related question. Is there a way to have the underlying data go into just one new worksheet when you double-click/drill-down on a cell? Right now Excel adds a new worksheet for every cell you drill-down on. Thanks! Cynthia "watkincm" wrote: One of the really neat features of a pivot is that by clicking on a pivot cell, it displays a new worksheet of the underlying data that makes up the cell value.... Unfortunately, this is having unpredictable results - some times many more rows are returned than the value in the pivot cell. Can anyone tell me why this is - or am I doing something dumb...? -- Mike Watkins -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
BTW...I really like your website. I've been doing quite a bit of research
lately for budget spreadsheets for my employer. Most sites are very unorganized with too much information and business. Your's is laid out in a clear and very useful manner. Cynthia "Debra Dalgleish" wrote: No, you can't select a destination for the data that's created. Excel adds a sheet, and places the data there. lovemuch wrote: I have a related question. Is there a way to have the underlying data go into just one new worksheet when you double-click/drill-down on a cell? Right now Excel adds a new worksheet for every cell you drill-down on. Thanks! Cynthia "watkincm" wrote: One of the really neat features of a pivot is that by clicking on a pivot cell, it displays a new worksheet of the underlying data that makes up the cell value.... Unfortunately, this is having unpredictable results - some times many more rows are returned than the value in the pivot cell. Can anyone tell me why this is - or am I doing something dumb...? -- Mike Watkins -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying pivot cell underlying data
Thank you! I'm glad you like it.
lovemuch wrote: BTW...I really like your website. I've been doing quite a bit of research lately for budget spreadsheets for my employer. Most sites are very unorganized with too much information and business. Your's is laid out in a clear and very useful manner. Cynthia "Debra Dalgleish" wrote: No, you can't select a destination for the data that's created. Excel adds a sheet, and places the data there. lovemuch wrote: I have a related question. Is there a way to have the underlying data go into just one new worksheet when you double-click/drill-down on a cell? Right now Excel adds a new worksheet for every cell you drill-down on. Thanks! Cynthia "watkincm" wrote: One of the really neat features of a pivot is that by clicking on a pivot cell, it displays a new worksheet of the underlying data that makes up the cell value.... Unfortunately, this is having unpredictable results - some times many more rows are returned than the value in the pivot cell. Can anyone tell me why this is - or am I doing something dumb...? -- Mike Watkins -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Referencing Data in a Pivot table. More Excel 2003 misery | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| data in cell not corresponding with entry | New Users to Excel | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Hybrid Mode
