Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
Hi,
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.
Eduardo