Hi All,
Kindly have a look at the excel file.i have day wise data its Based on the current month only
Here is the scenario Dimension should be week .and also i have 2 Expression 1st is the Net and 2nd is the Current its in the Column RunRate .
Net Run Rate Data we should consider till the end of month but when comes to current run rate it should show up to today only
if i am in the 5 th day of nov it should show the avg for both the project A and B but when i click on the single project it should show the single project and if i am on the 6th day i want to show the avg only for both project similarly if i click on single project it should show the 6th day in week one .but when comes to 8th day .in week one i should see the 7 th day data and in week 2 it should show 8th day data others week should be null and the week should be split by 7 days .w1 to w4 contain seven days each in week 5 remaining days ! !
