Incremental Percentage Monthwise

[Anonymous]

Hi Everyone,

I have a requirement to show the monthly incremental percentage of Revenue. Here i have created a concatenated field with Year &'-' & Month as a dimension. Please tell me how can i show the monthly incremental percentage as shown in excel & image..

[its_anandrjs · Accepted solution]

In the straight table chart use

Dimension:- Year &'-' & Month

Expression1:- sum(Revenue)

Expression2:- (sum(Revenue) - above( sum(Revenue))  ) * 100 / above( sum(Revenue))

Note:- in the sort properties select the Year &'-' & Month and only select Load Order this will done in the front end level only you can achieve this in the script level also.

Regards,

Anand

[maxgro]

see attachment

[its_anandrjs]

In the load script you can achieve this by the below code

Data:

LOAD * Inline

[

Month, Revenue, OutPut

Jan, 40, -

Feb, 60, 50

Mar, 75, 25

Apr, 100, 33.33333333

May, 125, 25

June, 150, 20

];

NewTable:

LOAD

Month,

Revenue as Rev,

( Revenue - Previous(Revenue) ) * 100 / Previous(Revenue) as PrevRevenue

Resident Data;

And in chart take Dimension and Expression

Dimension:- Year &'-' & Month

Expression1:- sum(Revenue)

Expression2:- sum(PrevRevenue)

Note:- In the sort properties select the Year &'-' & Month and only select Load Order.

Regards,

Anand