| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zero values in Pivot Tables
Hi all,
I have a PivotTable: 1st col: 2nd col: Dates(Row fields) Sales(Data fields) 01.01.08 100 01.02.08 150 01.03.08 0 01.04.08 120 And that one 01.03.08 row is automatically hidden, because it contains zero value in its data field, consequently it will not be shown in diagram also. Could you suggest me How can I show it in my PivotTable (Diagram)? The point is that it's shown and checked in filter list, but anyway it's not shown in result PivotTable. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using text values in Pivot Tables | Excel Discussion (Misc queries) | |||
| Calculating from values in pivot tables | Excel Worksheet Functions | |||
| Pivot Tables - Ranking Values | Excel Discussion (Misc queries) | |||
| Pivot tables with zero/null values | Excel Discussion (Misc queries) | |||
| Supress Zero Values on Pivot Tables | Excel Discussion (Misc queries) | |||
Threaded Mode
