I have a discreate column ( Pay Period number ) from ( 1 - 26 ) & another column ( Date ) ( 2010, 2011 ,.... , current ) .
I already have filter in the dashboard ( Pay Period number ) . However I want to set the default value to be the most recent Pay period taking into account the most recent year also. How can I connect the date column with the pay period column
Thank you for your help
