group by columns

I have a (successful) query that Groups Rows by a business unit name, and sums a few columns to give totals those units. In a previous step I had already filtered my data to just be one month so I could check my totals against the manual report we use. Now I have opened it up to all the dates...

Hi! My data set has 117,000 rows and 14 columns. It is at an item and week level. There is a week column, an item description column, 11 columns of characteristics that describe/classify the item, and finally the value column (cost). Is it possible, via M code or otherwise, for me to group by...

Hello there everyone! Im wondering if its possible to do this or not, or maybe some way i can achieve this. What i want to do is make a few groups of a few columns each in a pivot table, and then be able to use a slicer or timeline to be able to select which of the groups i want to see at any...

Hi MrExcel Community, my name is Dominika and I'm looking for a VBA code help. I need to automate some of my Excel work for the sake of completing my dissertation on time, but I'm new to VBA. I have data that have following columns: year quarter code number1 number2 The data are properly sorted...

Hi all, I have a quick question about performing "group by" in excel. I currently have to 2 columns named, "name"' and "number" as shown below. Name Number Balance 2000 Balance 300 Balance 200 Sales Deduction 20 Sales Deduction 30 ROI 20 ROI 10 Balance 29 Sales Deduction 1000 ROI 90 Sales...