1 of 1 people found this helpful
You could use a calculation with code like:
WINDOW_MAX(IF Last() == 0 THEN SUM(Sales) END)
Make sure it is computed Table Across (specifically addressing by date) and make it discrete. Then you can place it on Rows to control the sort order. Place it to the left of the field at the level of header you want to sort (either Customer or Region). You can control ascending or descending by adding a negative sign: e.g. -WINDOW_MAX(IF Last() == 0 THEN SUM(Sales) END)
Finally, you can hide the headers for the field since you are only using the headers to control the sort and not for visual display.
Hope that helps!
Yes this worked, Thank you!