R
RobN
There is an option with Pivot tables (In Layout and Format) to show "0" in
the "For empty cells to show:" field
However - I find that if all the fields are empty, then "0" is not shown. ie
a "0" will only appear in any of the blank field only if ,at least, one of
the other fields has a value.
Is there a way to always have a "0" show even if all the fields are blank
(empty)?
Rob
the "For empty cells to show:" field
However - I find that if all the fields are empty, then "0" is not shown. ie
a "0" will only appear in any of the blank field only if ,at least, one of
the other fields has a value.
Is there a way to always have a "0" show even if all the fields are blank
(empty)?
Rob