Get instant live Excel expert help with Pivot Tables
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to use he data in the pivot table to reproduce the same charts for october,
Solved by X. W. in 15 mins
Hello, I am having problems with PowerPivot and changing data sources. The pivot tables are disappearing and not able to update data source.
Solved by X. L. in 25 mins
I need someone to use an Excel pivot table to summarize several tabs with common cells into a summary tab.
Solved by D. W. in 15 mins
I need my pivot table pie chart colors to remain the same when filtering the data
Solved by K. B. in 18 mins
Need help doing pivot tables. please take a look. thanks
Solved by T. U. in 19 mins
Need help doing pivot tables, please create a new tab for your answer. Name the tab Question 2.1
Solved by Z. J. in 18 mins
I have a data set that lists month from January 2015 to September 2018 in the first column. In the next 24 columns is the name of a group and their corresponding number of members in each group during each month. I am looking to create a pivot table with three size buckets based of the current months size to allow for slicers when looking at the graph.
Solved by T. F. in 14 mins
I've got an Excel spreadsheet that has two sheets in it that will be the EXAMPLE called Orange County Agent County Final. Inside this document, the Sheet named Data has all Real Estate Agent information. I need a 2nd PIVOT TABLE Sheet named PIVOT that will AGGREGATE the AGENTS by COMPANY NAME. NEW COLUMN will be ADDED totaling out the number of AGENTS per COMPANY so that I can rank them from MOST to LEAST. Inside each COMPANY, when you click you should see ALL AGENTS AND ALL THEIR CONTACT DATA including NAME, COMPANY, ADDRESS, PHONE, EMAIL. EXAMPLE sheet was done by your company. They should be ranked from largest to smallest.
Solved by F. C. in 28 mins
In the Profit Analysis worksheet:
a. Create a Pivot Table using numeric data from Profit column.
b. Display the total profit for each of the four classes of cars.
c. Display the total profit for Airport as well as the Downtown location.
d. Row and column calculations (sum) are required so that the total profit for EACH location and the total profit for EACH carclass are visible in the pivot table. There must be a grand total (sum) that represents the sum of ALL profit.
Solved by T. D. in 23 mins
What is pivot table definition and how to build a pivot table in excel? Please help me.
Solved by F. A. in 22 mins