1 of 1 people found this helpful
Have you tried a calculation below
if [Age Bands] = 'Under 9' then
elseif [Age Bands] = '9-14' then
elseif [Age Bands] = 'Not Applicable' then
And use this field as sorting?
Thanks for your reply Zhouyi. I will try this and get back to you.
I think except sum, others should work as the calculation actual create the value for each record, so you can't use sum.