Expression ignores Dimension but is still limited by Dimension
I have what I think is a very complicated question.
I have a Chart that has 1 Dimension and 3 Expressions and the user can make Year and Month selections.
Dimension: Year Month (YYYYMM)
Expression 1: Inventory $
Expression 2: Turns $ (Sale Cost / Inventory $)
Expression 3: Sales $
What I’m trying to do is calculate annualized (current Year to Date, less than equal to the Dimension) Turns $ for each row (1 row for each month), but instead what I’m getting is only one month Turns $ per row.
When I try to use TOTAL I get the max Turns $ for the Year selected for each row rather than the annualized (current Year to Date, less than equal to the Dimension) Turns $.
When I change the Dimension to show by Product or by Company Name it calculates correctly because there is no time restriction so I know the base formula is correct, I just can't figure out how to calculate using time (Year to Date) and ignore the Dimension while still limiting the data to the Dimension.