Pivot Table Question : If statment in Pivot Table??

S

seve

I have looked for this answer but have not found it.

I want to.....Count all widgets when account info ="".

I have 8,000 inventory records. I only want them counted in the pivot
table when it has not been sold or is not currently being rented.



Can I do this in a pivot table?

Many thanks,

Steve
 
B

bpeltzer

Can we assume you have a column that indicates the record's status? If so,
drop that column into your pivot table's Page field, then use the page
drop-down to select only those meeting your criteria. (You could also put
the status in a column field, which gives you a bit more flexibility if you
need to see more than one status. Then you'd use the column field drop-down
to select the status code(s) you want, and look at the row subtotals in the
right-most column).
 
Top