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