My cube contains sales data. Some cube cells are empty (no value).
When using pivot table to display data, those empty cells are not displayed.
Pivot table just omit them. That makes my report liking something missing.
How to display the empty cell on pivot table?

Thanks in advance.

by default the pivottable ignore the empty rows & columns
open the property page of the pivottable and check or uncheck the empty
rows/columns options.

"Mike Torry" <MikeTorry (AT) discussions (DOT) microsoft.com> wrote