Hi. I think this is a simple answer but I'm struggling today ...
I know that excel can do this perfectly well with a pivot table but I need it in a report so it can be emailed daily to certain teams.
We have a list of stores who order 1 item and I need to have the table show a total number of how many stores ordered 1C, how many 2C, how many 3C and so on. I can get it to show what I need when I add in the store number/name so it splits it down but as soon as I remove the store number and name the qty ordered just pops back to the total ordered.
Is there a way I can tell it to show it by 1C, 2C, 3C etc ... as I am only interested in totals not on a store level.
Normal looking:

When I add customer it splits it by Case level:

How I would like it to look:
