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 have several sheets of item (tens of thousands of items) with their locations (100+ locations) and quantities in each location. I am looking for an efficient way to pull the data for several hundred items from the lists of tens of thousands. I need to be able to organize the data by item number, location, and quantity in each location. I have used pivot tables to very nicely organize a large quantity of data but, have not been able to pull the specific data I need from the pivot tables.
Solved by T. Y. in 27 mins
Hi, I'm having trouble with pivot tables in Excel
Solved by O. D. in 15 mins
so i created a summary page for sign ups, using the info in pivot tables, on far right of my summary sheet im trying to get a yes next to the names if that person has signed up. i need it to do a partial match of the name in column k ive tried using =countif('ja event'!$a2:$a52,"*$k2")
Solved by F. F. in 19 mins
Hi I'm trying to make a performance dashboard to monitor performance. Ive made the pivot tables but I can't seem to be able to add in a variance column so I can monitor changes. Any help is much appreciated as I am a beginner! After I have done that I will attempt to put the information on the dashboard page.
Solved by O. H. in 25 mins
Although I am applying filters to my source data, when I go to make a pivot table with those specific filters, it is still using all the data. How can I create pivot tables using filtered data?
Solved by A. S. in 16 mins
I need help with pivot tables, My example is very complicated but all online tutorials are too broad and simple
Solved by E. C. in 21 mins
I need help with pivot tables I want to learn
Solved by M. D. in 17 mins
Hi, I have a question regarding pivot tables....was hoping you'd be able to help
Solved by C. C. in 19 mins
This is a continued session. I need help with the PTO Report tab. The template I used only shows the employees data for one employee at a time from the drop down menu. I need to have access to all of the employee's PTO balances at one, for calculation purposes. Although I do want to keep this tab as is, I need to create either another tab, multiple tabs, or as a column added to the end to the Employee PTO Data tab. with the total available PTO for each. I need the data from the PTO Report tab AJ6 to appear in the Employee PTO DATA tab down the G column for each employee on the drop down menu on the PTO Report tab. I also need a new column in the H column on the Employee Data page to automatically fill with each employees information from the AL30 on the PTO Report tab. I basically need a listing of all of the Employee current PTO balances. And I will also need a listing of all the PTO hours used which overtime will appear on AL30, but will show as 0 for now. Need Pivot tables.
Solved by T. C. in 20 mins
Hi, may I insert pivot tables in a Google documents spreadsheet?
Solved by V. E. in 15 mins