Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table with Blank Cells | Excel Discussion (Misc queries) | |||
Pivot Table -- Suppress blank cells | Excel Discussion (Misc queries) | |||
Pivot Table - hide blank cells | Excel Discussion (Misc queries) | |||
Pivot table blank/empty cells | Excel Discussion (Misc queries) | |||
Counting blank cells in Pivot Table | Excel Worksheet Functions |