Hi,

I have a pivot table whose data contains (among other items) Salesperson, Week, and Sales (summed $ amounts). I've arranged the view to be something like this:

Please Login or Register  to view this content.
The questions I want to answer are...
  1. What is the highest individual sales amount per week?
  2. Who had the highest sales each week?
I would like to be able to create a line chart where the x-axis is time (weeks) and the y-axis is the highest individual sales. So, in this example, it would be $11 (Sara), $18 (Fred), and $6 (Sara). Bonus if I could put their names next to the data point.

Since this data is in a pivot chart whose dimensions and fields are quite variable, I was hoping I could use calculated fields or something (as opposed to traditional spreadsheet formulas).

Any suggestions?

Thank you.