Countif in pivot table

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

Guest

Scenario:
- simple pivot table that summarizes revenue for three products: a,b,c
- each product may have hundreds of underlying data records that relate to each unique sale of product

Q: how can a calculated item (assume item as field seems to work only on totals not individual records) be used to create the following:

Product Revenue > $25,000
A $280,989 13
B $345,119 7
C $549,009 11

I want to know for each product, how many transactions (i.e. records) there are over $25k (in this example) for the given product while also still totaling all records. Also, I don't want to have to show all records in order for this to work, if possible. Thanks.

Jeff
 
I think I'd use a helper column in the original data.

=If(a2>25000,1,0)

Then just use it in the pivottable.
 
Thanks Dave. Simple works

Be nice if you could do this through PT though--would enable a lot of useful analysis

----- Dave Peterson wrote: ----

I think I'd use a helper column in the original data

=If(a2>25000,1,0

Then just use it in the pivottable





Jeff wrote
 
Bummed that there is no way to do this. I thought of adding the extr
column but it seems like a bulky solution. Too bad for us
 
Back
Top