Get instant live 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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Each lead we receive is entered into a data table. I've been trying to create a pivot table to show: 1. the number of leads each month 2. the total cost of these each month 3. the number of sales each month As an additional feature, it would then also be great to have a slicer to select between the Sales Reps. I am new to Pivot Tables, can someone please help me out with this?
Solved by V. U. in 12 mins
Hi I'm pretty much a beginner in Pivot Tables in Excel and I'm having a few niggling issues. I doubt they would take an expert to resolve, but still need some advice. How does this service work? Thanks.
Solved by O. E. in 11 mins
Hi, I'm having a problem with pivot tables. I want to see my company's employees age in groups of 30-39, 40-49 and so on. The problem is my excel knowledge is not good enough to merge individual numbers into these groups. Meaning I can see how many of them are 30, how many are 31 etc. How do I merge the age into these groups?
Solved by B. Y. in 12 mins
I don't know if what I want is possible. It is based off of pivot tables and graphs
Solved by E. J. in 21 mins
I don't know if what I want is possible. It is based off of pivot tables and graphs. I need it to filter by date.
Solved by D. J. in 20 mins
Hello I was given a source data to analyze of a national food chain. I have made pivot tables to try to understand the data but am unable to understand how to better understand the data. Can someone look at my spreedsheet and guide me
Solved by T. D. in 30 mins
I am getting the error "We Couldn't get data from the Data Model. Here's the error message we got: Object reference not set to an instance of an object" when trying to refresh all on my office 365 excel sheet. I have ~ 15 pivot tables. All of their data ranges are linked to one table via the table name. Any suggestions?
Solved by C. H. in 22 mins
I have a worksheet I need to turn into pivot tables, but I don't know how to turn the info in my worksheet into usable info for the pivot table.
Solved by E. H. in 24 mins
I need excel pivot table help! Cannot update the latest entered data on my pivot tables
Solved by I. Y. in 15 mins
Hi, I'm a certified excel expert in solving problems relative to the Formulas, Pivot tables, charts, VBA/Macros.
Solved by C. U. in 28 mins