troubleshooting Question

Pivot Table and Pivot Chart

Avatar of Michael Franz
Michael Franz asked on
Microsoft Excel
3 Comments1 Solution576 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros