Hi guys. I'm new to Tableau. I would like to calculate the sum of the previous 4 weeks before the week number filter. When I tried using Window Sum, the sum fails when the week number filter is applied.
Basically, I want it to show this if the person selects week 7 in the filter:
Blouse 18 Shirt 2 Pants 10 Sweater 9
If the person selects week 10 in the filter, it should show this:
Blouse 15 Pants 5 Sweater 9.
Any ideas? Thanks.
6 answers
Hi, @Laura Flores
Here's a sample from the past four weeks.
<calc and parameter>
We are adding calculated fields and parameters. Please check.
*If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.
