Grouping in reports based on 4 variables

Hi Community

Trying to work out best way to produce a report based on 4 variables…which is just one more than the max in reports. I can't be the first one to have this conundrum and I would be keen to understand how others have resolved it. Columns, in the hierarchy I would like to report are:

Goals/Strategies/Sub-strategy/Measure

There is no linkage between any of them - selecting a goal does not define a strategy. Similarly for sub-strat and measure. I'm sure there must be a way by using helper columns and am hoping someone has solved beforehand 🙂

Find more posts tagged with

Reports

Accepted answers

Kelly Moore

Hey @RayB

Could you add a helper column to the sheet that is a concatenation of all 4 columns then group by the new helper column? You should be able to hide this column in the report, I think.

=Goals@row+Strategies@row+[Sub-Strategy]@row+Measure@row

Would this work?
Kelly

All comments

RayB

…forgot to add in the post that the report would group projects based on the four variables

Kelly Moore

Hey @RayB

Could you add a helper column to the sheet that is a concatenation of all 4 columns then group by the new helper column? You should be able to hide this column in the report, I think.

=Goals@row+Strategies@row+[Sub-Strategy]@row+Measure@row

Would this work?
Kelly

RayB

ha! so simple and so obvious when someone points it out 😁 I suspect your solution will work perfectly ! Thanks Kelly - off to give it a go.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.