Custom Column Reporting - Adding a 2nd Grouping based on the Calculated Field

[MaryPe9]

I have a Project report with a calculated field (using text) and need to add a second grouping based on the calculated field.  Would appreciate guidance on how to do it.  Thank you! 

[Kurt_Jones · Accepted solution]

Mary,

You can include calc fields in the Grouping area of a report, see below. The problem you may run into is if the calculated field is working with multiple choices then the grouping will show every combination used by users.

[kautuk_sahni]

@MaryPe9 just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!