Calculate Current Month Sales=Last 2 months sales*0.5

[neha_shirsath]

Hello Community,

I need your help for below mention issue.

See the attached file.

I have sales and budget data and i want to calculate current month sales based on logic-

(0.5*sales value of M-1) + (0.5*sales value of M-2)

Means Suppose we are in April month then = (March sales*0.5)+(Feb sales*0.5)

Here i'm getting the Sales after calculating above expression but that calculation I want for APRIL month,

now its giving me for FEB & MARCH.

Same for Budget only Budget will give me next 10 months Budget.

Thanks in Advance.

-Regards,

Neha

[Kushal_Chawda]

How your input data look like?

[neha_shirsath]

It contains date field ,company details and Sales value.

[Kushal_Chawda]

Can you show the screenshot of few lines of input data?

[sasikanth]

HI,

Please find the attachment may be helpful

If not please share your Data

[neha_shirsath]

!

See the above screenshot.

[neha_shirsath]

Hi Sasi,

Thanks for your help.

Excel data is only for test purpose, my data is coming from QVD,

Month is in row format only so i don't need to use cross table in that.

[sasikanth]

please share some sample data

[qliksus]

Hi,

Do you want something like the below?

Actual Data:

O/P:

the use something like this

rangesum( before( sum(Data) ,1,2))