Each folder is independent counsel selection, ie selection does not lead to next or previous folder. Help to select the month that contains data. I'm working with spreadsheets and in some cases the data is not updated. So, I need to catch the last month that contains data, I got it with this expression: = MONTH (MAKEDATE (Only (ANO), COUNT (TOTAL (1 <group = ('BENEFICIARIES'), YEAR = {$(#= Only ( YEAR ))}>} distinct MES))) and this year I'm bringing to this formula: = YEAR (today ()); These two expressions are used in an action "Select Field" in the folder. But the problem is that each folder is independent of selection, to trigger another folder and select any other year, and then back to the folder deselect the month that contains data in the folder that uses this action.
