- In million for ∑ Values >0
- Show blank for ∑ Values =0
Simply use below in Value Field Settings → Number Format → Custom and type:
#,##0.000,,;-0;;@
Example: Below 'LOS' values are equal to 0 but now appeared as blank
Hide 0 Pivot Table Values or Show As Blank
August 09, 2018 |
Labels:
How To
Say you have a pivot table. You want to format the number:
Simply use below in Value Field Settings → Number Format → Custom and type:
Example: Below 'LOS' values are equal to 0 but now appeared as blank
Simply use below in Value Field Settings → Number Format → Custom and type:
Example: Below 'LOS' values are equal to 0 but now appeared as blank
Subscribe to:
Post Comments (Atom)
Simply wanna remark that you have a very nice web site , I enjoy the layout it actually stands out. excel expert near me
ReplyDeleteI’ve read some good stuff here. Excel Calendar Template free
ReplyDelete