Dimesnion % Calculation

[waqasshah]

Dear Experts,

I need your help. Actually I  need to calculate the percentage between the dimension columns. Please review the attached picture. The top 2 percentage calculations marked with red sign are my desired results. Can anyone please tell me how to do these calculation in chart or on a text box ?

Thanks in advance

Regards

Waqas Shah

[sunny_talwar · Accepted solution]

Check attached...

Script changes

ActivitySales:
LOAD *,
	 SubField(ActivityFinancialYear, '/', 2) as Year;
LOAD * INLINE [
    SalesItem, ActivityPrice, ActivityDate, ActivityMonth, ActivityFinancialYear
    1, 100, 01-01-2015, January, 2015/2016
    2, 200, 20-01-2015, January, 2015/2016
    1, 150, 15-02-2015, February, 2015/2016
    2, 210, 22-02-2015, February, 2015/2016
    1, 250, 01-03-2015, March, 2015/2016
    2, 270, 10-03-2015, March, 2015/2016
    2, 300, 19-04-2016, April, 2016/2017
    2, 600, 13-04-2016, April, 2016/2017
    2, 970, 25-05-2016, May, 2016/2017
    2, 120, 28-05-2016, May, 2016/2017
    2, 330, 03-06-2016, June, 2016/2017
    2, 650, 06-06-2016, June, 2016/2017
    2, 170, 07-07-2017, July, 2017/2018
    2, 960, 09-07-2017, July, 2017/2018
    2, 150, 10-08-2017, August, 2017/2018
    2, 235, 11-08-2017, August, 2017/2018
    2, 344, 14-09-2017, September, 2017/2018
    2, 496, 15-09-2017, September, 2017/2018
    2, 483, 06-10-2018, October, 2018/2019
    2, 798, 27-10-2018, October, 2018/2019
    2, 101, 23-11-2018, November, 2018/2019
    2, 502, 30-11-2018, November, 2018/2019
    2, 659, 19-12-2018, December, 2018/2019
    2, 710, 03-12-2018, December, 2018/2019
];

Expression

=Num(Sum({<Year = {"$(=Max(Year))"}>} ActivityPrice)/Sum({<Year = {"$(=Max(Year)-1)"}>} ActivityPrice)-1, '##.#%')

[waqasshah]

Many Thanks you are a star..