| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table data need to show zero even no data under column
I am using pivot table data it contains 2 rows one is dealer and other one
is product & there are some sales persons selling that product which was in page, Now all the sales persons cant sold all the product then also I need Data as 0(Zero) under column |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table data need to show zero even no data under column
Sumanthkaka wrote:
I am using pivot table data it contains 2 rows one is dealer and other one is product & there are some sales persons selling that product which was in page, Now all the sales persons cant sold all the product then also I need Data as 0(Zero) under column Not sure if this is what you mean, but try right clicking the PT, Table Options, For empty cells, show: 0. Another possibility is double clicking the dimension field buttons (dealer, product) and checking "Show items with no data". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Does Not Show Data | Excel Discussion (Misc queries) | |||
| Column width of Pivot Table data goes back to default when data refreshed | Excel Discussion (Misc queries) | |||
| Pivot Table- Show Data % of | Excel Discussion (Misc queries) | |||
| Show all data in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
Hybrid Mode
