Subtract the base value with months?

[gauravgg]

Hi all

I have the scenario  .

i have the following few rows of the table

And i have created the following graph

I want to Keep Budget as base and subtract the budget with the monthly amount and show the variance .

i.e

i want a bar beside every monthly bar which shows Budget-monthly difference

i the above case

Budget FY-18 has 1000 Budget

May-17 has 800 Value,I want one more bar beside May-17 which shows Budget FY-18  - May-17 (ie 1000-800=200)

Same apply for all the months of that FY year

[Frank_Hartmann]

add one of the following expressions:

above(sum(Value))-sum(Value)

or

sum(TOTAL{<[Price Pointer]={'Budget FY -18'}>} Value)-sum(Value)

hope this helps