PIVOT TABLE WITH BLANK CELLS
I need some assistance - I have created a pivot table with a lot of data from
an excel spreadsheet. When you click on the data in the pivot chart to open details about what the data represents it sorts the data wierd because there are blank cells. It will not ignore these cells unless I put a zero in there...?? Is there someway to have the pivot only display data that is populated within a certain column? |
PIVOT TABLE WITH BLANK CELLS
You can base the pivot table on a dynamic range, counting the cells with
data in a specific column. There are instructions he http://www.contextures.com/xlPivot01.html Tanya wrote: I need some assistance - I have created a pivot table with a lot of data from an excel spreadsheet. When you click on the data in the pivot chart to open details about what the data represents it sorts the data wierd because there are blank cells. It will not ignore these cells unless I put a zero in there...?? Is there someway to have the pivot only display data that is populated within a certain column? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com