Hello.
I use Excel 2016.
I created a Power Query table that has columns for Order#, Order Item#, Part#, Quantity, Item Value, Customer, Address, Order Status and Order Date.
I see that the "Subtotal" menu option is greyed out. How would I subtotal Item Values by Order# or by Customer like I would in a regular Excel spreadsheet?
Thank you.
Bookmarks