×Sorry to interruptThis page has an error. You might just need to refresh it.
Unable to find an action for 325;a: {"id":"325;a","state":"SUCCESS","returnValue":{"componentDef":{"descriptor":"layout://rl-User-VIEW-FULL----force_highlights-_1-0-674b574567657471726c42666756465a66576b5766673d3d.c"},"original":"markup://force:recordLayout","creationPath":"/*[0]","attributes":{"values":{"mode":"VIEW","offset":0,"inContextOfComponent":"force:highlights","isDraft":false,"record":{"LastModifiedDate":"2025-02-06T20:29:30.000Z","Email":null,"FirstName":"Jonathan","AboutMe":"I use Tableau by day and write about Tableau by day and night.","PostalCode":null,"Title":null,"City":null,"MiddleName":null,"Name":"Jonathan Drummey","SystemModstamp":"2025-02-06T20:29:30.000Z","CompanyName":"PATH","CommunityNickname":"jonathandrummey","Suffix":null,"Phone":null,"State":null,"CreatedDate":"2020-04-25T13:26:52.000Z","Street":null,"Country":null,"LastName":"Drummey","Id":"0054T000001O4jxQAC","LastModifiedById":"0054T000001N0mYQAS","sobjectType":"User"},"pageSize":-1,"type":"FULL"}}},"error":[],"components":[{"componentDef":{"descriptor":"layout://rl-User-VIEW-FULL----force_highlights-_1-0-674b574567657471726c42666756465a66576b5766673d3d.c"},"original":"markup://force:recordLayout","creationPath":"/*[0]","attributes":{"values":{"mode":"VIEW","offset":0,"inContextOfComponent":"force:highlights","isDraft":false,"record":{"LastModifiedDate":"2025-02-06T20:29:30.000Z","Email":null,"FirstName":"Jonathan","AboutMe":"I use Tableau by day and write about Tableau by day and night.","PostalCode":null,"Title":null,"City":null,"MiddleName":null,"Name":"Jonathan Drummey","SystemModstamp":"2025-02-06T20:29:30.000Z","CompanyName":"PATH","CommunityNickname":"jonathandrummey","Suffix":null,"Phone":null,"State":null,"CreatedDate":"2020-04-25T13:26:52.000Z","Street":null,"Country":null,"LastName":"Drummey","Id":"0054T000001O4jxQAC","LastModifiedById":"0054T000001N0mYQAS","sobjectType":"User"},"pageSize":-1,"type":"FULL"}}}]}
@Sudarshan Dhiman (Member)
Hi, I have been trying to understand what you mean with: "When a category is deselected in "Furniture" the graphs show = Sales - Discount + profits. If all category on the list are deselected, graphs will show = Sales - Discount + profits on all category."
So, what do you mean with:
a. When a category is deselected in "Furniture"? Do you mean that if Furniture is deselected, then it should show the value for the remaining category
b. If all category on the list are deselected, graphs will show = Sales - Discount + profits on all category? Do you mean that when no value is selected it should show the value for all categories?
However, I think you may create a Set, and then a calculated field like:
IF {COUNTD(IF [Category Set] THEN [Category] END)}=0 THEN TRUE
ELSE [Category Set]
END
Or maybe you just need the opposite one:
NOT [Category Set]
Attached you will find the workbook.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
Category Set Neg