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

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