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:
The questions I want to answer are...- What is the highest individual sales amount per week?
- 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.
Bookmarks