Hi,
I Have a problem when calculating variation between years.
I have 3 charts, Chart 1 and 2 the values are correct, but the chart 3 does not bring right values (value for chart 3 should be the same as chart 2.
Expression for Chart 2
(Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
- (Above(Total ((Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
)),Count(DISTINCT Total<Year> [Year]))))
This is teh expression I'm using: and the result is not right.
(Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
- (Above(Total ((Sum(if(Year='2015' or Year = '2014' or '2016' ,Actual/1000))
)),Count(DISTINCT Total<Year> [Company Code]))))
Could you please help me with this?
best regards,
