Can you share your workbook with us?
Have you tried making duplicates of Apparel and Accessories and using them in calculated fields? I don't think you would need to group them.
see the attached superstore example with just 2 groups -
you need to create copies of the data - 1 for each new group - and union them together
in the combined data you will have a field "Table Name" one name for each copy
you then need to create a single calc filed similar to the one shown below
if ([Table Name]='Orders' and [Sub-Category] ="Accessories" )
([Table Name]='Orders' and [Sub-Category] = "Appliances" )then "Acc - App"
([Table Name]='Orders$' and [Sub-Category] ="Accessories") or
([Table Name]='Orders$' and
[Sub-Category] = "Art" )then "Acc - art" end
it will return something like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
new groups.twbx 2.3 MB