Subtract the base value with months?

gauravgg — Sat, 23 Sep 2017 06:28:39 GMT

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

Re: Subtract the base value with months?

Frank_Hartmann — Sat, 23 Sep 2017 07:57:46 GMT

add one of the following expressions:

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

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

hope this helps