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 / Microsoft Dynamics AX (Archived) / Summarize grid lines
Microsoft Dynamics AX (Archived)

Summarize grid lines

(0) ShareShare
ReportReport
Posted on by Community Member

Hello

I do have a grid containing Items on different warehouses with 8 columns of calculated values. Means an itemId can occur multiple times.

Now I want to add a fasttab on my form where I have a summarization of the grid above by Item

example:

Grid 1:

Item A Warehouse 1 2 5 6 3
Item A Warehouse 2 3 6 1 7
Item B Warehouse 1 1 4 8 5
Item B Warehouse 3 3 2 4 1

Grid 2:

Item A 5 11 7 10
Item B 4 6 12 6

How can I get this done?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Create a View where you could use an AOT Query that has sum/grouping as per your requirements.

    Then you can use that view on your form as a datasource, and display the values in Grid 2.

  • Community Member Profile Picture
    Community Member on at

    Hello

    Thanks. oh yes. I am sorry I forgot to mention that there will be some fields where I have to enter values manually. After this I have to do some more calculations with the values in this grid

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Then maybe you can do InnerJoin with your other table to the view where you may enter the values. Or use edit methods for those fields.

    https://msdn.microsoft.com/en-us/library/aa637541.aspx

  • Community Member Profile Picture
    Community Member on at

    Hi

    I am so sorry but the consultants just told me right now that they want it different.

    in the second part (fastTab) they only want to see the cumulated values for the selected Item in grid 1

    So if there are 4 Lines with Item A they and they select one of this lines they want to see the cumulation of all lines with Item A.

    this cumulation should be updated evrytime they change data in the grid above (changing values in the line)

    In addition there will be some fields in Grid2 where values are calculated from values in the gridline (of Grid2)

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Then the solution is the same, except the View used for Grid 2 is joined to the other datasource in Grid 1 to make the item filtering happen.

    I do not get the calculated values bit within Grid 2, but it is possible most likely with computed columns on the View.

  • Community Member Profile Picture
    Community Member on at

    ok lets summarize:

    1. I have to create a query to sum the values add a range to the ItemId (selected in grid1)

    2. create a view with the query as ds

    3. Join DS of Grid1 to the DS in View

    4. somehow create computed columns on the view

    Right?

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Yes it sounds correct, if I got your requirements right. Number 4 is the only question since you did not give more detailed explanation, but most likely it is computed columns if you want values based on multiple rows from the same dataset.

  • Community Member Profile Picture
    Community Member on at

    ok thx.

    For your info. the computed columns should have values based on calculation from the values in Grid2(G2) line. e.g. G2.column3-G2.column4 or a percentage (G2Column5 is x% from G2.column2) and so on

  • Community Member Profile Picture
    Community Member on at

    short question again.

    wouldn't it make sense to create a table with my sum values (Temporary), fill it with a query and calculate my additional values?

  • Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Why would you do extra steps of looping, calculating then inserting, if a View can do the same on-the-fly faster?

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Basit Profile Picture

Basit 1

#1
GL-01081504-0 Profile Picture

GL-01081504-0 1

#1
Roya Profile Picture

Roya 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans