Hi All,
I have the below data
| Period | Value |
| Dec-2018 | -0.74% |
| Nov-2018 | -0.33% |
| Oct-2018 | 0.22% |
| Sep-2018 | 0.65% |
| Aug-2018 | 0.79% |
| Jul-2018 | 0.75% |
| Jun-2018 | 0.59% |
The for set time frames (such as QTD,YTD,etc.) I need to create a formula such as the one below. This would be for QTD
(Aggr(Sum({<[Period] = {'Dec - 2018'}>}Value)+1,Period) *
Aggr(Sum({<[Period] = {'Nov - 2018'}>}Value)+1,Period) *
Aggr(Sum({<[Period] = {'Oct - 2018'}>}Value+1,Period))-1
so my formula would = ((-.74+1)+(-.33+1)+(.22+1))-1 = -.0845
Does anyone have an idea of how to make this formula dynamic for a set period ?
