Hello,
I am trying to force a specific row of data in a straight table to no matter what always be listed last. Even if the other 7-8 columns of data are interactively sorted this one row always stays listed last.
I am trying to do this by locking the Standard Company Name that I want to stay listed at the bottom of the table.
if([Standard Company Name] = 'Company ABC', dual('Company ABC', 1), [Standard Company Name])
The above works until you interactively sort by any other of the columns such as Revenue Amt, Forecasted Revenue Amt, etc.
Is there a way to call out this one specific Standard Company Name to be listed last even when you sort on other columns? I want it to be part of the table, but to be left out when the sorting changes.
Thanks!