Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is a field call Start_Selling_date for each item every year in a item dimension table. I would like to calculate the accumulated sales amount of each item starting from the Start_Selling_Date of current year till today, how can i achieve it? Is it impossible to use set analysis to do it because every item may have different Start_Selling_Date?
Hi,
In the expression tab, there are options for "Accumulation":
First check to see if these options fit into your needs.
But this won't restart every year, will it? I think RangeSum(Above()) should be the solution. But would be difficult to say much without looking at the underlying data