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 have an excel document which has multiple columns. One of the columns has a Item Number. This product code can be in the listing in multiple places in the same column. What i want to do is to sort the list out where it wont show the single Item No's just the multiple ones in a list.
Someone said you can do it in a pivot table but its beyond me.
Need to know who to do i as ill need to do it each month
Solved by D. W. in 11 mins
Need help with displaying information on a pivot table.
Solved by X. B. in 24 mins
After making my pivot table, I want to retrieve the specific data for a cell. So if I have a pivot with different grade levels and I want to see the 100 2nd graders, how do I get to that data?
Solved by C. H. in 15 mins
can't figure how to format a pivot table/chart the best way
Solved by I. S. in 28 mins
Looking to get a formula applied to a pivot table; simple formula that is derived from two columns that can change
Solved by X. W. in 16 mins
I need to create a formula that looks at data in a pivot table and produces a result from that information; as data in the pivot table changes, so should the formula results
Solved by T. Q. in 12 mins
I want my dates in my pivot table to come out correctly at the moment the data is being sorted by days
Solved by O. Y. in 18 mins
Pivot table, not coming up with same totals as original data.
Solved by Z. A. in 19 mins
I have 4 worksheets that I'm trying to aggregate the information into a pivot table. While I am able to pivot with multiple destinations, the information is not "pulling" correctly.
Solved by S. S. in 30 mins
What's the easiest way to find out the pivot table percentage of two data that contain with the total sales quantity and return sales quantity by simply a click of sale item name?
Solved by S. Y. in 11 mins