I have two different sheets in my dashboard where one is current month and the other is last months count. what i am looking for is being able to change both numbers by one filter. so if i pick feb as my current month and i want jan in the last month sheet
Add a column in the last month sheet with current month value. For Jan2018 , the new column should have Feb2018 and so on. Make the name of this new column same as the name of month column in the current month sheet. Then apply the filter in both worksheets.