How can I make the data show in percentage when one item in a list of inventory are both zero in the pivot table instead of getting #DIV/0! error? (a row includes two columns: Cost: $0.00 and Sales: $0.00 and rest of the rows includes two columns: cost and sales varying from $.01 to $1,000,000?)
Bookmarks