I would likely do this with Calculated fields if these groupings are going to be permanent in your data.
For instance - to change the specific values to negative, use:
If [Sub-Category]="Fasteners" then -[Number of Records] elseif
[Sub-Category]="Tables" then -[Number of Records] else
[Number of Records]
and then change the Sub-Category field to allow for the desired grouping:
When "Fasteners" then "Binders"
When "Tables" then "Chairs"
See the right column here:
Making the changes with the calculated fields will allow you to utilize totals, sub-totals, and other calculations and views with fewer complications.
I hope this helps,
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.
Thank you for your solution, however I still need to display "Fasteners" and "Tables". So we are halfway there. I am starting to think this may be one of those attempts to perform an Excel-like function within Tableau, meaning applying a calculation to specific rows/columns.