I am trying to create a table which will always just show sales for stores for the latest week. Is there anyway to use set analysis on my dimension to only show the sum of sales per store for the maximum of the week #?
Re: Dimension Set Analysis? Maximum week for a table
That is helping the expression pick the most recent week per each store. As I pointed in my expression, New York didn't have any data for week 2... for New York the max week is 1. So, if you want to show New York's sale for week 1, you can use FirstSortedValue expression rather than using set analysis.