Hello and thank you for taking the time to read this. It seams that I have stumbled Across a problem. I had a PowerPivot Table that in the row field has Sales Rep on top and Date on the bottom. In the values Field I have the count of Sales, so that when I open that rep it gives me a list of dates that have the count of sales for that Date. thats Great!
Now what I would like is next to the name when the drop is open or closed I would like to show the max sales for that person . in the date. all help is welcome.
Now what I would like is next to the name when the drop is open or closed I would like to show the max sales for that person . in the date. all help is welcome.
