In our MD&A report we have a large table that summarizes our variances for Operating Expenses by a number of specific categories. I created a section in our spreadsheet with 20 rows for each variance category so that we had plenty of lines for potential explanations for why a category went up or down in a given month. I built in columns that rank each explanation by significance using specific formulas, so that each month all we had to do was sort by the Ranking column, and filter by the Hide/Show column, which would automatically update the whole table with all of the explanations and categories in the right order based on the overall OPEX variance, and significance of each individual explanation.
We transitioned this month, and in Next Gen Documents, we can't seem to find the filter feature for the table. The rows from the last month that were hidden by the filter are currently hidden but there's no filter in the first row like in Classic Documents. The table is over 800 rows long, so going through and unhiding and hiding each of the relevant rows would be extremely time consuming and defeat the purpose of building this table in the first place.
I found the sort feature by highlighting the table and right clicking on it, but I don't see any Filter feature...
Please let me know where the Filter button is, or if it's not currently available, please let me know the most efficient work around.