"IF" statement in a pivot table.

E

Elizabeth

I need help in writing a "IF" statement in a pivot table. My data consists
of sale orders numbers that may have several line items - I am trying to do a
count on the sale orders and Excel count each item as a separate sales order.
Is it possible to write a "IF" statement in a pivot table? Does anyone have
any suggestions as to how I should approach this?
 
N

Nick Hodge

Elizabeth

If you have an order # them leave out the items and then simply set the
order # to 'count'. You will not be able to count the unique orders in the
table with the items in (AFAIK), as Excel will count every occurrence of an
order # even if this is only to mark 3 items on the order

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top