Actual vs Budget

[Anonymous]

Hi All,

Please help me in solving the below scenario,

Sample data  format:

Month,Actual,Budget

Jan,10,10

Feb,20,12

Mar,30,32

Apr,40,41

May,50,52

Jun,60,61

Jul,70,72

Aug,,66

Sep,,77

Oct,,88

Nov,,99

Dec,,88

Scneraio : 1) Actual data is upto jul month and budget data is upto dec month, i want to show the actual and budget value upto jul month not considering the budget data from aug to dec in a straight table

Scneraio : 2) want to get accumlated value , example if i select mar month in a list box, straight table should show data actual and budget value for

jan,feb and mar value

thks in advance

[jvitantonio]

Hi, please see the example attached.

[Gysbert_Wassenaar]

See attached example

[Anonymous]

Hi,

Thanks a lot for both of you guys, it worked

[jvitantonio]

Please mark the post as correct or helpful.