Applying Filters to 'Groups of Rows'

samgray85

New Member
Joined
Dec 1, 2014
Messages
11
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

Board Regular
Joined
Apr 29, 2014
Messages
101
right click on a bracket in the pivot table and select filter->value filter -> Count of delivery > 200
 

Forum statistics

Threads
1,077,678
Messages
5,335,621
Members
399,029
Latest member
JSO

Some videos you may like

This Week's Hot Topics

Top