We are having a requirement were we need to retain a particular value in a measure for calculating rest of the fields, and we are unable to achieve that.
Scenario :
We have a report were we need to calculate a field “growth”. As you can see it is the difference between (month) 2016 and December 2015
Eg: Mar 2016- dec 2015 = 4835-4824 = 11
Month
DEC 2015
Jan 2016
Feb 2016
Mar 2016
Apr 2016
May 2016
Jun 2016
Jul 2016
Aug 2016
Sept 2016
Total Count
4,824
4,824
4,820
4,835
4,836
4,837
4,838
4,833
4,834
4,831
Growth
0
(4)
11
12
13
14
9
10
7
For this we need to retain the total count of Dec 2015 in an attribute , which we are not able to do. Can you please provide us with the syntax for this.
