You can also use your index() formula by changing it to the following:
if index()>5 then 'Rest' else attr(Country) end
Hope this helps!
Hi Tracey and Richard,
Thank you both for your replies. I have implemented both your solutions and they work...in a table. My problem is that I want them in a Pie. I can't seem to get this to work, as when I take away the origional 'country' variable they don't work. See the attached. Any suggestions?
Grouping by Top 5vii.twbx.zip 24.5 KB