date filtering

[Anonymous]

Hello, I have a report with several campaigns sort by weeks by budget. Some campaigns are paused or spend little and those I would like to filter. But I can't use a specific budget which is more than x because the campaign may start a few days ago. 

I would like to filter something like, when the budget is more than x in the last 7 days, show it.

actual week 41

Something like this should be a result:

Thanks

campaign	week 38	week 39	week 40	week 41
campaign 1	300 (USD)	0	50	30
campaign 2	0	0	0	150

[Fowmy]

@Anonymous 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn