How do select last 6 working days in set analysis?
I have a date in my app called 'application date'. I want to be able to show revenue for the last 6 working days broken by down by different product sold. As you can see in the below image, the dates go back to 06/30/2021 when I am viewing this sheet on 07/06.
I want to see these dates : 06/25 and 06/28 - 07/02 when I view on 07/06. (last six working days)