I am having trouble filtering for the minimum date value when it is in the row of a pivot table.
As a simple example, suppose you manage a team of 3 salespeople and you want to show how many of each product they sold in their starting month.
So you have:
1) Bob - Started Apr 2012
2) Mary - May 2012
3) Jim - June 2012
In the Pivot Table:
Row Label #1: Salesperson
Row Label #2: Month
Row Label #3: Product Type (Many types)
Values: Quantity Sold
So we have:
BobApr
Product 1 Sold
Product 2 Sold
Product 3 Sold
May
Product 1 Sold
Product 2 Sold
Product 3 Sold
Jun
Product 1 Sold
Product 2 Sold
Product 3 Sold
MaryMay
Product 1 Sold
Product 2 Sold
Product 3 Sold
Jun
Product 1 Sold
Product 2 Sold
Product 3 Sold
JimJun
Product 1 Sold
Product 2 Sold
Product 3 Sold
Is there a way to filter the MINIMUM month for each salesperson within the pivot table? I am trying to get only Apr performance for Bob, May performance for Mary, and Jun performance for Jim
If not, what is the easiest way to capture it automatically?
Thank you for your time.
Bookmarks