Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the Pivot table shown below I want to calculate the growth of nos over the year 2016
After the calculation of growth out put report should look like below
My expression for Nos is as follows
sum(Nos)
Year is a dimension
I tried following expression to calculate growth but it does not work. Pls help
if(RISK_YEAR=2017,(sum({<RISK_YEAR={'2017'}>} Nos)-sum({<RISK_YEAR={'2016'}>} Nos)),sum({<RISK_YEAR={'2016'}>} Nos))
Hi Friends
I manage to calculate growth my pivot table now looks as shown below
My expression for growth is (Sum(Nos)/Before(Sum({<RISK_YEAR>}Nos)) - 1) * Avg(1)
However There is blank Column (3 rd Column ) which I want to hide. Can you suggest a solution please
We have done the Pick(Dim(....)) approach so many times before... are you still not able to implement it?
Hi Sunny,
I tried with this Expression
IF(match(YEAR,'2017'),(Sum(Nos)/Before(Sum({<RISK_YEAR>}Nos)) - 1) * Avg(1))
still the blank row appears