Thank you for your reply.
Unfortunately this seems to just display the sum total for each order rather than banding them.
Basically, I am looking for 10+ bands (£0 - £10, £10 - £20, £20 - £30 etc.) which refer to the basket value of each order.
Within those bands, I am trying to report the total sum of sales for all orders with a basket value within those bands.
Hope you can help,
Thank you in advance.
Nevermind, this does actually band them, however I have no control over the bandings. Do you know if I can specify the individual brackets? For example, after 40 - 50, I might want 50-75. Otherwise, do you know if I can force the bandings to appear in incremental numeric order to a limitation of, say, 10?
Thank you again for your assistance.
Use if statement in that case
If(Sum(Sales) > 0 and Sum(Sales) < 10, Dual('0-10', 1),
If(Sum(Sales) >= 10 and Sum(Sales) < 20, Dual('10-20', 2),
If(Sum(Sales) >= 20 and Sum(Sales) < 30, Dual('20-30', 3),
If(Sum(Sales) >= 30 and Sum(Sales) < 40, Dual('30-40', 4),
If(Sum(Sales) >= 40 and Sum(Sales) < 50, Dual('40-50', 5),
If(Sum(Sales) >= 50 and Sum(Sales) < 75, Dual('50-75', 6))))))), Invoice)