Hello, I am really hoping someone may be nice enough to help me out with this one. I think it should be pretty simple for folks on here.
We have some meal orders coming in from the online store, on a daily basis I need to email a summary to the chefs showing the food to me made in the coming days.
I am not sure if I should use a pivot table? or what? here are a couple of pics:
Order-Details.xlsx - Excel.png
Order-Details.xlsx - Excel-Pivot-Table.png
And here is some sample data should be attached.
I clearly dont know what Im doing and I have put a pivot table in there..The summary would be fine if thats how it looked but the totals shown on my pivot table are wrong. I think it is because it is only adding the first reference to an item and missing the others.
Thank you very much
Miked
Bookmarks