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

[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

 

[smartin]

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

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