Link to home
Start Free TrialLog in
Avatar of Michael Franz
Michael Franz

asked on

Pivot Table and Pivot Chart

I have one data source. The source contains among other things.... Sales Person, Number of Customers, Number of Policies, and Total Revenue. I want to pivot table & Pivot Chart these items, but I want the Pivot table to contain Policy Count, Customer counts and Sum of Revenue. I want the chart to be the same, but do not want to show Revenue because it skews the chart with policies being in the 100's and revenue being $100K to $1.0M.. We also have month.

Right now I have

Report Filter - Sales Person
Column - Sum Values
Row - Moth
Values - Sum Policy, Sum Customer, Sum Revenue
Avatar of Harry Lee
Harry Lee
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael Franz
Michael Franz


I had to go with option #2. Thanks for the help.
Glad I can help.