| 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? |
| 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 | |||
Threaded Mode
