Showing Only Non-Zeroes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this is simply solved by using a filter. But here's the case..
An Order Sheet which shows Item Description with qnty, price/ item and extended price (price/item * qnty). My problem is that the items aren't just laid out as a whole. They're actually subgrouped. For ex.:
Accounting Supplies
Calculato
Printe

Marketing Suppies
Brochure
Manual

How do I filter where I only see rows which have quantities ordered and still show the parent account (i.e. Accounting Supplies and Marketing Supplies)
 
Can you add an =sum() to each of the category rows?

Then when you filter, you'll see that one, too.

(And give it a custom format of ;;; (makes the cell look empty))

(Or maybe in a column that's out of the print range if that's easier.)
 
Back
Top