Forum Discussion
Solved
UNIQUE function on table with filters
I have a table (fed from SQL). where the table filters are used to select data by date range. My issue is that using the UNIQUE function on the table data does not appear to take account the table f...
WillSmyth See attached. If that's not what you want, I don't know. Note that I filtered the table to show only items from 2023.
By the way, better to place the SORT(UNIQUE(FILTER(....))) formula in another sheet to avoid it from being hidden in case the filter hides the top rows of the sheet.
Riny_van_Eekelen
I have added the new column FILTERED with the formula =AGGREGATE(2,3,[@[TX_DATE]])
The FILTERED column displays value 0 regardless of the filter set on the table.
I have added the new column FILTERED with the formula =AGGREGATE(2,3,[@[TX_DATE]])
The FILTERED column displays value 0 regardless of the filter set on the table.
WillSmyth See attached. If that's not what you want, I don't know. Note that I filtered the table to show only items from 2023.
By the way, better to place the SORT(UNIQUE(FILTER(....))) formula in another sheet to avoid it from being hidden in case the filter hides the top rows of the sheet.