calculations by date

Tue, 14 Apr 2015 17:00:08 GMT

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.

Re: calculations by date

maxgro — Tue, 14 Apr 2015 17:45:47 GMT

if I understand may be adding a field (branchid) to link the tables

for branch code <> 003 030, branchid = branchcode

branchid branchcode

-1 003

-1 030

x x

y y

Wed, 15 Apr 2015 08:21:52 GMT

thanks.

but its not working.

any other suggestions please