Sales Forcaste

[neha_shirsath]

Hello Community,

I need your help.

I have Sales & Estimated Budget as shown in the image.

I need a format where

Condition 1:

if i'm in Oct month then i want to  all estimated value of Oct, Nov & Dec.

Condition 2:

if i'm in November month then i want to see real sales of Oct in estimated budget Column with Estimated value of Nov & Dec month.

Condition 3:

if i'm in December month then i want to see real sales of Oct & Nov in estimated budget Column with Estimated value of Dec month.

Thanks in advance.

Regards,

Neha