If you look at the attached excel file I have start dates and end dates on first sheet. Using this I am creating the count of all members that were active on the 15th of each month.
At the same time I have premium data in another table which I am aggregating by month. This is simply sum of premium and dimension is monthname(Policy Date). This policy date is different from the date coming on the data in the first sheet.
I want to create a table which will show number of members active on Jan 15 in first column and then total premium for Jan in second column.
Would appreciate any idea / help in this regards.
