I am trying to select N number of months back fin a given metric based on an in Input Metric.
The Target Metric is dimension by Type in the rows and Month in the Column. The Input metric is dimensioned by Type and I have assigned a differing number of months to each type. The Calculation Metric in which I am placing the Formula should offset and select the value N Number of Months back based on the Input Metrics Months.
Here is an example formula:
Formula Metric:
‘TargetMetric’[SELECT: Month - InputMetric] but this throws an error about the month dimension.
How can I select a certain value from the target metric N number of months back based on an Input Metric?
