Hi Community,
I'm trying to sort a list of dimensions when there is or is not data. So all in the table as opposed to only the ones that have data. Attached is a workbook and what I've tried. I can get the sort to work on Name or County when there is a shape in the year but the bottom half which is displayed using the Table Layout > Show Empty Rows will not pick up on the sort and what we are trying to do is a full sort on the whole table.
I don't understand why the calculation is not picking up the bottom half of the table so any help is appreciated.
Thank you
Tom
Hi @Thomas Pierre
the issue is that the values have been filtered out of the visible data table
and you are working with a discrete name combination - so there is nothing to sort
-- I.e. yoiu don't have a record in the data table to sort on after the filter is applied - you will need to scaffold the data set to do what you want - see the 3rd example of https://jimdehner.com/2021/02/19/faq-series-when-and-how-to-scaffold-data/ where this user faced a similar issue
