Get instant live Excel expert help and learn how to change the source data for a Pivot Table
“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 am trying to make a pivot table with multiple columns of task with alternating forecast and actual dates. The rows need to be months and yes. When i create my table the numbers in the table do not match the totals in the data source.
Solved by F. E. in 18 mins
• Specify the data source that drives each of your KPI (from what data files, and which worksheet
your data source can be found). (5 marks)
• What Excel features will you be incorporating into presenting that KPI (Chart, Dynamic chart
label, Pivot Table, Conditional Formatting, Data Bar, Slicer, Macro, Custom Controls… etc.). (5
marks)
• Once you finalize the design of your dashboard, put together a wireframe and indicate where
each KPI can be found. (5 marks)
These are the direction and i have somefiles with it but i am a confused about this.
Solved by F. E. in 19 mins
How do you think go about creating twenty pivot tables from a multiple and heavy data source in excel.
Solved by X. A. in 21 mins
Is it possible to sort a pivot table by a field that is included in the data source table but one that is not included in the pivot table itself? If the answer to this is 'no' then alternatively is their a way of including it (to be able to sort by it) and then hiding it as it is not needed in the pivot table (except only to be able sort by it - if you see what I mean)!
Solved by S. Q. in 27 mins