Can I use a report Shared column as a grouping in the report?

[CBuckwal]

Hi, 

I have a shared column that I would like to use as a grouping in the report. The shared column text mode is below:

column.0.linkedname=direct
column.0.namekey=FDN DA Project Type
column.0.querysort=DE:FDN DA Project Type
column.0.sharecol=true
column.0.textmode=true
column.0.valuefield=FDN DA Project Type
column.0.valueformat=customDataLabelsAsString
column.1.displayname=DA Request Type
column.1.linkedname=direct
column.1.namekey=Assistance Requested
column.1.querysort=DE:Assistance Requested
column.1.textmode=true
column.1.valuefield=Assistance Requested
column.1.valueformat=customDataLabelsAsString

Is this possible?

Thanks

Cathy

[skyehansen]

If you make a calculated field on your object that contains these two fields, and merge the two answers, you would be able to have one grouping that expresses these. Otherwise, that's not possible with current grouping functionality.

[CBuckwal]

Thanks, I'll try that.