I want to total all Lead records and chart them for each week. However, all I know how to do is make a copy of my Leads TO and join it to itself by the calc field that has Year ( DateCreation ) & WeekofYear (DateCreation). But how would you doing it using a Calendar Table (with a date for each record from aboiut 1990 to 2089?
See attachment for how I did it -- relating the DateYrWeek field from the Portal TO (LeadsbyWeek) to the main table (LEADS), but how do you do the relationships using a Calendar table? The broader question is how do you use the Calendar table? Provide an example or two (an explanation vs. a file is fine to start).