Oct 07 2022 05:11 PM
Can someone help me with my pivot chart hw?
Oct 07 2022 05:31 PM
Oct 07 2022 05:49 PM
Start by reviewing some existing discussions, and note how questions and answers are presented. That should explain how to ask a question.
In the case of homework problems, beware that usually we will not provide "turnkey" solutions. You need to do the work yourself.
In that case, you might present the homework assignment verbatim (for our benefit), but you should also present your attempts to solve the assignment yourself.
If you are completely lost, we can offer direction. But it is better if you ask specific Excel questions ("how to calculate `25% more` of some value") instead of "how do I implement this assignment".
Ideally, attach an Excel file by clicking "browse" at the bottom of the reply window. If the forum does not permit that, I can suggest other ways to provide the Excel file.
But at the very least, you should provide a screenshot in one form or another.
Again, look at how other people have presented things in other discussions here.
Oct 07 2022 05:57 PM
Oct 07 2022 07:52 PM
Great job on pulling the files together.
Unfortunately, I cannot help you any further because I don't know anything about PTs and PCs. Also, I wonder if you are looking for an Office 365 Excel solution. (You should specify, if that's the case.) I don't use Office 365 Excel.
I'll try to get the attention of one or two frequent contributors who might be able to help.
In the meantime, have you searched for youtubes that might help?
In particular, look for PT and PC youtubes by Kirt Kershaw. I cannot speak for anything he might have prepared for PTs and PCs. But his youtube on importing XML files was extremely helpful, clear, concise and understandable to my American English ears.
Good luck! Sorry that I cannot be more helpful.
Oct 08 2022 02:07 AM
Have you created a pivot table based on the data yet? That shouldn't be too hard.
See for example Create a Pivot Table in Excel
You should move the main_category field to the Columns area and to the Values area too.