Rolling-up information from sheet and reports. Unable to group information.

I am creating a report that pulls data from sheets and one other report. The information rolls up fine from both the sheets and report but it does not allow me to group the information from the report. For example, I want to group by program and then sub-group by sub-project. I keep getting a "Blank" for the group and the sort for the information from the the report. Checked for typo etc. The data is there. Help.

Best Answer

Answers