Skip to Content
0
Former Member
May 10, 2010 at 10:03 PM

How do I sum a total "count" by month?

79 Views

Hi can you assist me instructions on how to sum by month?

Can someone tell me how to sum the total "ICN (identifying classification numbers) Unduplicated Count" by month?

I have claim data from Dates of Service December 1, 2006 - June 30, 2007 sorted in ascending order with Y on top half of screen (Y because they are indicated as being managed care and N on the bottom half of screen because they are not managed care).

But I need to sum the Y indicator's by month.

In Objects I have variables:

Claim Type - dimension

From Date of Service (between 12/1/2006-6/30/2007) - dimension

Managed Care Indicator - dimension

ICN Undup Count - measure

From Date of Service Month - detail

Thank you,

Saundra