Hi All,
I have sheet 1 having all monthID like below
Another Sheet same as Sheet1
I have another field called "Version ID" which shows the month of the revision and it is constant and changes whenever revision cycle changes.
So whenever User Opens the Dashboard sheet 2 should show 201807 value , but when user clicks on the sheet 1 Month ID , my Sheet 2 value should show respective value like
Users lands on Dashboards he wants to see 201807
When User Click on 201809 in sheet 1 Then --> Sheet 2 should show 201809
When user release the action --> Sheet 2 should show 201807 ( Which is value equal version ID )
Thanks in Advance.
Regards,
Naveen Bandla
HI Chris,
Attached the workbook.
regarding the release of action i am talking about below section in the filter action
Regards,
Naveen Bandla