Get instant live expert help with Pivot Tables

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.

Hi, I'm having trouble with pivot tables in Excel

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")

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.

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?

I need help with pivot tables, My example is very complicated but all online tutorials are too broad and simple

I need help with pivot tables I want to learn

Hi, I have a question regarding pivot tables....was hoping you'd be able to help

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.

Hi, may I insert pivot tables in a Google documents spreadsheet?