×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"}}}]}
Hi @Twinkle Bansal (Member)
Try UNIONing your data together so you have two sets of rows.
Or alternatively related your data to a two row sheet with a relationsip calc 1=1
RowNum
1
2
That way you'll get two sets of data. Then for set two you can group A, B and C. And filter out the others. Calcs will be something like
IF RowNum=2 AND Column1 IN ('A','B','C') THEN 'A,B,C'
ELSEIF RowNum=1 THEN Column1
END
Put that on filters and filter out NULLs
Also put it on Rows and you should find you get what you're after.
You basically need add in marks for the extra group somehow which is why I suggest the above.
Ta, Steve.