Skip to Content
0
Jun 06, 2018 at 01:51 PM

Counting how many stores have ordered certain amounts

45 Views Last edit Jun 06, 2018 at 02:31 PM 3 rev

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:

Attachments

capture.png (2.6 kB)
capture1.png (17.5 kB)
capture3.png (6.3 kB)