Showing data as day wise but dimension should be week
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 ! !
Finally if its not under stable completed week should contain last day data on that particular week and the current week data should be today date kindly help to resolve this one
