PFA the snapshot of the bar chart that I have created.
The blue bar indicates the actual % values are calculated using cummulative total of actual nos.
The red bar shows the targeted value which is available for Q1 2015 onwards only.
Now I want to show bars for 2015 only. Hence as of now only data related to Q1 2015 will be seen as first quarter is going on.
Moving ahead the rest quarter's values will be seen.
I want to remove bars for previous years. But when I restrict the dimension using calculated dimension or dimension limits tab, I do get data for 2015 but the actual values gets disturbed as shown in the "wrong data snapshot".
In your expression (Achieved retention), you are using above(). When you limit your dimension this above() gets nothing to refer. To work with such requirement you have to use Aggr(). Your expression is too long ! I am too lazy to work with it. . Try with Aggr().