Pivot table, to get number of records with values (>0)

[andy.k]

What i'm trying to do is get total count of rows with 0 value, then total value of rows with values >0.

I got 6 columns, equipment, port, value1, value2, value3, value4

In pivot, need Total # of ports, then in value1-4, if value is >0, then count how many ports with value > 0 for each column, value1, value2-4

This i need for graphing purpose, to see over month, my number of ports with values over total number of parts available.

How can this be done?

[:) Sixthsense :)]

Yes, we can do it

Please attach a sample workbook with expected output for better understanding