Can I use a report Shared column as a grouping in the report? | Community
Skip to main content
Level 4
August 26, 2024
Question

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

  • August 26, 2024
  • 1 reply
  • 397 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor
August 26, 2024

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.

CBuckwalAuthor
Level 4
August 26, 2024

Thanks, I'll try that.