Pivot table data need to show zero even no data under column

S

Sumanthkaka

I am using pivot table data it contains 2 row’s 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
 
S

smartin

Sumanthkaka said:
I am using pivot table data it contains 2 row’s 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
Click to expand...

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".
 
Top