Pivot Table Counts

[kiki443]

How can I use Pivot table to count based on criteria?

I have a pivot table report and it's broken down by type of invoice, region, and products. There is also a column for the age of the invoice.

I want to see the number of invoices that are in a specific region, with specific products, and are 0-5, 6-15, and 16-30 days old.

This is my 2nd attempt at a pivot table and I'm stuck at this point.

Any help is appreciated. Thanks

 

[Dufus]

kiki443,

Can you add a column to your data to indicate which time bucket the invoice is in?

Dufus

 

[kiki443]

Pivot table counts

I can add another column but there will be six different buckets. Should I use nested countifs?

Not sure how to put them in the right bucket.

 

[GorD]

The pivot table will put them in the time buckets, you just need the actual age, which should just be a subtraction

 

[kiki443]

I have the age column but it counts how many there are per age. How do I get them into the right bucket.

If I do it before creating the pivot table won't I need to use countif or something to get the bucket it should be in?

How can I do it directly from the report?

 

[GorD]

Select one of your ages, which will either be in the row or column field, right click and select group and outline then group.

 

[kiki443]

Thanks, that seems to work, I just have to tweak the criteria for the buckets so that it will reflect the ones I need.

Than you again.