create webi report of difference of manpower between each month

[Former Member]

Hi Expert

I want to create webi report. I have one dimension object calendar month and one measure object manpower. I want difference of manpower between each month. Like

Cal month manpower difference

Dec 2016 8277

Jan 2017 8580 303

Cal month manpower difference

Jan 2017 8580

Feb 2017 8588 8

Cal month manpower difference

Feb 2017 8588

Mar 2017 8390 -198

I am not able to subtract month to next month manpower. Please help

[amitrathi239]

trythis

=(manpower)-previous(manpower)