Sub Summary Based on Date Calculation
I want to create a sub summary report based on a date calculation.
The attached layout has two sub summary parts.
The first summarized by Edition.
The second by the calculation field Survey_YYYY_Mo. This field is based on another calculation field (Date_Convert) that converts a timestamp to a conventional date. Survey_YYYY_Mo converts Date_Convert to only the year and month of the survey because I want them grouped by Year and Month to track trends.
The goal is to identify trends for each version of the product over time based on the year / mo the surveys were taken. e.g. if three surveys were submitted in Feb 2014, their results would be summarized into a single row 2014 - 02.
I'm sorting by Edition and Survey_YYYY_Mo but instead of getting summary data below each Edition, I'm getting one row with a question mark ? in the Survey_YYYY_Mo field. I would expect each version to have multiple rows - one row for each group of surveys by year - mo they were taken.
Can anyone tell me what I'm doing wrong here?