Forum Discussion
custom order for legend, sort using another column
Anonymous , first of all, the sort column will not be dynamic, it will not use a measure. I think tying to create a column using a measure, that is giving an issue.
You can sort it on overall sales. Add a random number to make it different
Super UserAnonymous , first of all, the sort column will not be dynamic, it will not use a measure. I think tying to create a column using a measure, that is giving an issue.
You can sort it on overall sales. Add a random number to make it different
amitchandak Thanks. Based on what you wrote, I threw away my manually created Client Table. I created a referenced table from my data table, grouped the new table by client name and counted the rows (records) to create the workload numbers. I sorted the new little grouped table by client alphabetically, and added an index column. I created one more column, Force Rank, by adding the record count plus the index (divided by 1000) to break any ties that might form. Linked the Client fields from the two tables, did Sort By Column on the Force Rank and all good now. Thanks.