Calculating Budget Value..

[#1]

Hi all,

I have six month total values of budget and i am spend some amount value into budget value for every month how to deduct spending value for every month(minus value into every month values), For Exmaple July month i have 1000 here i am spend 100 july month itself, now aug month values 900,again i am spend 75 now sep value 825 like..please help asap.

Regards,

K.S.

[#2]

Hi All,

like ,Cumalative value  minus every month spend value.

Regards,

K.S.

[#3]

Hi,

Please help me ASAP now.little critical.

Regards,

Senthil.K

[antoniotiman]

Hi,

maybe like this.

See Attachment.

Regrds

[#5]

Hi Antonio,

Thanks for your support.

Our company, as per policy  not allow to open other QVW documnets.please send me the script.

Regards,

K.S.

[antoniotiman]

I try.

Create variable vBudget = 1000

Dimension Month

Expressions in Pivot Table

1) Sum(Value)

2) If(Dimensionality() =0,vBudget,

vBudget-RangeSum(Top(Sum(Value),1,RowNo()))

Check TOTAL in Dimension Month