Sorting by Dimension not in table

[m_perreault]

Hi All,

I have the below table

Account	ID	Value	Typ	TDate	Grouping ID
Blue	555	1500	Open	7/31/2018	1
Blue	555	-1500	Close	5/31/2018	1
Green	444	1000	Open	6/30/2018	2
Green	444	-1000	Close	4/30/2018	2
Red	333	500	Open	4/30/2018	3
Red	333	-500	Close	2/28/2018	3
Blue	222	250	Open	3/31/2018	4
Blue	222	-250	Close	1/31/2018	4

I want the table to be sorted as above but I do not want to include the Grouping ID column. Does anyone have any suggestions as to how to do this?

Thanks,
Mark

[Nicole-Smith · Accepted solution]

Make your account dimension a dual, and it will sort on the numeric value:

=dual(Account, [Grouping ID])

[m_perreault]

Awesome thanks so much!