I created a Trial Balance that includes columns Accounts and related dimensions using a slice. I would like to sort the ascending by Account Number; however this is what I am getting (see below). How can I get this to sort correctly?
my suggestion would be to create an attribute that has only the account codes in - and then use this attribute to sort by. Problem is possibly because of the numeric and non numeric data