changes with respect to date

[#1]

Hi Experts,

i have a table with some branches & their corresponding branch codes.

the branch called Dundee and its branch code changed from 003 to 030.

the changes effect from march 23, 2015.

from jan 2015 to march 23, 2015 the branch code is 003.

i have another table which contains the working days for all branches & also table for sales & targets.

i got a pivot table which shows the targets & actual sales of all branches.

the targets have some calculations which depends on the working days of a particular branch.

if i select, jan 2015 or feb 2015, the working days have to pick up for the branch code 003

if i select march 2015, the working days have to pick up for the branch code 003 & 030(it should give the added value)

and if i select april 2015 and for the remaining months, the working days have to pick up for the branch code 030.

how can i do this.

please help in this regard.

[morganaaron]

Slowly Changing Dimensions sounds like what you're talking about. It'll all depend on what history you hold on your data, and how you want to attach this.

[ramoncova06]

use interval match IntervalMatch, this will create an entry for in between period

[#4]

hi,

thanks for your reply.

can u please help me with the script

[#5]

hi,

thanks for your reply.

can u please help me with the script

[morganaaron]

There's a technical guide at the bottom of that article that should give you a head start - give it a try first, happy to help if you run into issues along the way!