Hi, I'm trying to create an expression that gives me the sum of stock from only the LAST date of the current selection...
A basic equivalent of the tables used are...
I need, for any selections that may occur, the SUM([Stock Level]) only for the last date in the selection or the dimension in a chart. For example we might want to see a table with dimensions [Week] and [Category 3] and we would want to see the sum of stock for each category on the last day of each week shown in the table.
Also, the dimensions are not set in the tables/charts themselves, they are dynamic based on user selections/variables.