1 of 1 people found this helpful
I haven't tested this without an example workbook, but you could create a calculated field along the lines of:
if count [sub category] >1 then 'mixed category'
else attr([sub category])
Then use this as your title.
Thank you so much Chris, it worked for me.
Thank you Zhouyi!