Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
StockHistory:
Product ID
Date
Stock Level
Products:
Product ID
Category 1
Category 2
Category 3
Calendar:
Date
Week
Month
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.
Hope that's clear! Any help much appreciated! 
Darren
