web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management reporter : ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Management reporter : how to include two branches in the column?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

could someone please help? I've two branches that need to be include into the report, but don't know how to write the formula into the column area.

Thanks,

Annie

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Greg Byer Profile Picture
    Greg Byer 2,588 on at

    Hi Annie,

    Could you expand on what you are trying to do?  Are branches a segment of your account number?  If they are, there are a couple of way to do this.  

    You could create two FD columns in the column definition.  Then use the Dimension Filter cell and list the branch.  Each FD column would then filter in the branch that was defined.  For example, if I have branches 100 and 200, I could use the Dimension Filter and put 100 in one column and 200 in the other.  The columns would then filter in branches 100 and 200 into their respective column.

    The other option would be to use a reporting tree.  In the tree, you'd add two lines.  In the Dimensions column, you could select 100 on one line and 200 on the other.  You could then put this side by side in the columns by using the Reporting Unit cell.  Double-click in this cell, select the reporting tree and then select the unit.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 758

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 655 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 496

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans