Hello All,
I'm working on action filter, In source sheet i'm showing sum(sales) by week wise on bar chart and in target sheet I'm showing sum(sales) by week wise in pivot table. So I have applied action filter from source to target sheet, So here when I select one week in source sheet it has to filter from selected week to last 3 weeks data in target sheet.
Can somebody please help me on this to achieve it.
Thanks In Advance.
Regards,
Suresh
Good morning
Unfortunately that is not the way a filter works - filters exclude data from the table that underlays the individual worksheet so when you pass a single date form your source sheet to the target sheet you will filter the source sheet to that single date - consider using set actions or parameters and parameter action to accomplish what you want
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
