Link Two Pivot Tables then Return a Row Result

[ioswoody]

Hello

I am trying to link two Pivot Tables (see Sample File) to find out how many $ of revenue they are doing per connection

Pivot 1 (Connections) on the left is how many connections they have done
Pivot 2 (Revenue) on the right is how many $ in revenue they have generated

I would like to have "Revenue" pivot filter from the selection of "Connections" Pivot selection (so I only have to choose one) and then I would like the amount of revenue $ per connection to populate automatically to the right of "Revenue" Pivot

It would be great to be able to return all data from a store (then I could see everyone from the one store), not sure if this is possible

I am a novice; If you have a better way, feel free to suggest or adjust (it is the end result that I am interested in)
This is using Excel Mac version 15

Thanks in advance

[sandy666]

Try with Pivot Table and Chart Wizard - Alt D P (on Win, I don't know Mac)