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
Right now I have
Report Filter - Sales Person
Column - Sum Values
Row - Moth
Values - Sum Policy, Sum Customer, Sum Revenue
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad I can help.
ASKER