Day wise Budget logic help.

[lalitkgehlot89]

Hi

I have the following table

Budget:

load * inline

[

Plant,Month ,Value,Day

P1,Jan,100,MO

P1,Jan,105,TU

P1,Jan,108,WE

P1,Jan,95,TH

P1,Jan,74,FR

P1,Jan,120,SA

P1,Jan,130,SU

];

now want the data, Same day of the Month has same Budget.

ex:- Budget of all Mondays of Jan should be 100, Budget of all Tuesdays of Jan should be 105 and so on.

Please help me out to right the same logic.

Thanks,

Lalit Kumar

[sunny_talwar]

Connect your Budget Table to the Master calendar on Month and Day field... Have you tried this already?