1 of 1 people found this helpful
Can you use a row grand total?
For the weeks you can use a relative filter (assuming Tableau knows about you date is a date), and set for the last 4 weeks.
Thanks Alex. I should have expanded my question a bit more. In addition to seeing Latest 4 I would also like to see a Latest 12 and Year-To-Date. If I was only looking at one of those I think a row grand total would work perfectly.
The only option I can think fo at this point is to pre-calculate these total in the data source and read the periods in as discrete.
Product Wk1 Wk2 Wk3 Wk4 L4 L12 YTD
That is definitely your best option in that case