title: Calculate Months in Population
body: <p>I need to make an output table that lists clients in the first column,  followed by entry date and exit date, followed by columns with the months of the year as column headers. Desired output is a mark (X) in each month column for each month the client was a member of the population.</p>
  
  <p>Something that would look like a Gantt Chart, but instead of tracking Project Timelines, would track which months in a year a person was a member of a population.</p>
  
  <p>Tools available to me are WeBI, Excel/PowerPivot, maybe Tableau. I am going round in circles picking the appropriate tool because it will be used to fill out a form for a grant. I'm looking at some gantt chart templates, which may work, but i fear the funder is looking for an X in a particular column.  </p>
  
  <p>I know it's a very general question. I'd love some feed back and direction.  Thanks!</p>