Working with Pivot Tables in Excel 2007

[GrahamButler1970]

I am trying to work with a list of data and working out the number of items within that data which tally to set criteria.

If I have a list of 10 items which value to 100,000 and I need to look at 80% of this (80,000) and then find the number of items which add up to this value in that range.

I am trying to use pivot tables as I have multiple result criteria.

Any help gratefully received.

 

[cjcobra]

I do the pivot table, then copy all the cells and paste special-value. Take your percent, and sort.