Join two tables one has Date and other only have month
I have Below sales Data
CUSTOMER
RDATE_TIME
Sales
A
1/2/2005
20,578
B
2/2/2005
20,373
C
3/2/2005
22,381
D
4/2/2005
21,042
i get these data from data base. Then i have use a calender and have Year,Month, Day list boxes. To view data based on selection.
Here i have use drill down group year,month,day.
suddenly i get monthly data from one Customer. I need to add them to this report. Then i have put that data in excel and join it with my existing table. the problem i have is i don't have date for my summary data.
I can use date in that month for summary, but then all month data display under that date. Is there a way to solve this.
The problem is that you cannot determine the actual date of the information when you have only the month (or year and month). Any date you choose will not necessarily be correct. Either you obtain the date or change the granularity of your analysis to monthly data.