topic Re: Sorting by Dimension not in table in App Development

Sorting by Dimension not in table

m_perreault — Tue, 14 Aug 2018 18:42:54 GMT

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 — Tue, 14 Aug 2018 19:08:50 GMT

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

=dual(Account, [Grouping ID])

m_perreault — Tue, 14 Aug 2018 19:28:12 GMT

Awesome thanks so much!