Custom reports does not allow subgroups

Getting straight to the topic, This is my custom report:


left as it is it will generate a report like this:

It is repeating all the entries which make the report unbearably long. I want the sum of quantity and amount per group per sales rep and per day if possible.
but when I tick Groups to collapse I only get the sum of the first grouping which is Sales Rep.

That is correct Manager only uses “AND” operators. Your entry states that you group Customer by “Sales Rep.” AND “Group”. One is not a sub-group of the other, both conditions apply at the same time.

So it can’t be done. I should use Excel for now then. Is it possible to grab data from Manager in excel? Ultimately using power query directly with Manager.