Hello, is there a way to gather averages/info with formulas from rows that have been filtered out in the options settings of a table?
For some background, I like to filter information by month so that my page won’t lag. I keep a yearly log with an entry per day. So having 365 rows per year starts to make the page lag, and filtering out by month keeps the lag away. My issue is I still want to get the information off of the filtered out rows to display at the top so I can compare numbers.