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

I need help with pivot table basics. I'm having trouble creating a ratio to add to my pivot table
Solved by E. H. in 24 mins
I'm having trouble adding a pivot column calculating a ratio in my pivot table
Solved by F. C. in 18 mins
I need to change a pivot table macro. How do I do this?
Solved by C. C. in 15 mins
in sheet 3 worksheet, how to change the ranking of product on the chart so the product that generate the highest revenue will be the first, just like the pivot table and pls recommend the suitable title for this graph
Solved by I. E. in 14 mins
Hi there, I need the data in the pivot table "Raw Data" columns AJ-AM sheet to appear as displayed with the blank columns. Can you assist?
Solved by I. H. in 28 mins
I'm trying to group my frequency distribition table excel by the number of customers who purchased a specific number of items at their visit to the store. My row groups need to be 1, 2,3,4,5,6,7> So how can I group all the 7 purchase and higher visits in 1 row?
Solved by M. H. in 25 mins
Ranking with pivot table and running an exceptions check for 'bye' competitors . Also, replacing bye competitors with following rank.
Solved by E. W. in 16 mins
I am using a pivot table for disbursements. I have a sheet in my workbook with account numbers for named accounts. For example, account 1 = payroll. In my checkbook (which is my source data), I use numbers for my accounts. How do I tell my pivot table to use the name of the account instead of the number? (So it says Payroll instead of 1 in my Row Labels? ) Hope that makes sense???
Solved by F. A. in 27 mins
Complex multiple pivot table extractions for a list of competitors that need to gain additional slots when certain names are in a given category.
Solved by O. J. in 13 mins
Hi there, Is there a way to add multiple columns of data in a single pivot table?
Solved by B. Y. in 17 mins