Counting customers with spend between certain values
I'm trying to build a table which counts the number of customers spending in pre specified bands. Someone had asked a similar question a couple of years ago and got an answer which I can't make work for some reason.
In our data customers are location_id, sales are customer_gross_sales.
For my first spend segment I've written the following piece of set analysis: