I imagine you could have a dashboard which filters based on selections in each sheet. However, without a packaged workbook, this is a tough question to answer. If you have sensitive data, I would check out Anonymize your Tableau Package Data for Sharing.
Is this what you are looking for?
Furnishings = IF [Sub-Category] = 'Furnishings' THEN [Sales] else 0 END
Labels = IF [Sub-Category] = 'Labels' THEN [Sales] else 0 END
Accessories = IF [Sub-Category] = 'Accessories' THEN [Sales] else 0 END
If you have already found the solution, please disregard this.