Applying Filters to 'Groups of Rows'

[samgray85]

Hi.

Situation:

• I am analyzing data of a courier company.
• The data is organised into rows with each row representing a delivery from pickup to destination.
• I now wish to understand performance of the couriers over different distances (delivery lengths).
• The total distance of each delivery captured at the row level (e.g. it was 4 miles from pickup at A to deliver at B).

• In the Power Pivot window, I have created a calculated column that clusters deliverys into 1 mile brackets or bins.
• Each row now has a bracket descriptor in this column (e.g. 1 - 2 miles, 2 -3 miles, 4 - 5 miles).
• I've built a Pivot Table that has all the brackets as the row headings (e.g. 1 - 2 miles, 2 -3 miles, 4 - 5 miles) and a count of the number of deliveries in each bracket.

Question: I want to filter out any Brackets with a count of less than 200 deliveries. How do I do this?

 

[Tianbas]

right click on a bracket in the pivot table and select filter->value filter -> Count of delivery > 200