Hello Experts Exchange
I have a SSRS report that displays daily sales data, the user selects the date for the day they want to see.
I need to show target amount based on the day the user has selected.
I have two tables, one table has the target amount for the week. The second table has a percentage the shop should do on a particular day of the week.
Table 1 looks like this
Loc_ID Week_No Year Target
2000 26 2015 2225
Table 2 looks like this
Loc_ID SUN_Perc MON_Perc TUE_Perc WED_Perc THU_Perc FRI_Perc SAT_Perc
2000 0 16.54 15.19 14.9 15.69 22.12 15.56
I need to take the Target from table1 divide it by 100 then times it by the day of the week percentage from table 2
So for Mon day the it would be (2225/100)*16.54
But I need to select the percentage dynamically based on the date the user selects, how would I do this?