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 / Service | Customer Service, Contact Center, Fie... / Sum of all the record ...
Service | Customer Service, Contact Center, Fie...
Answered

Sum of all the record value in model driven table

(0) ShareShare
ReportReport
Posted on by Praajna 35

Hi,

I have a table view like this in my model driven power app

Depratment Number of Employee Number of Project
Dept 1 150 32
Dept 2 100 25

Now I want to add number of employee of each department and number of project of each department. I want to show it as below

Depratment Number of Employee Number of Project
Dept 1 150 32
Dept 2 100 25
Grand Total 250 57

How can I show this in the table. If anyone can help me on this that would be helpfull for me to complete my task

Thanks
Praajna


I have the same question (0)
  • Verified answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at

    Hi Praajna,

    In Dynamics 365, we cannot get total value directly in the table view as we can in excel.

    One way:

    You can create one report based on current table, then you can get total values:

    pastedimage1677724277029v6.png

    --Add these two column with 'Sum' type when you configure the report:

    pastedimage1677725238878v7.png

    --Run report:

    pastedimage1677725291536v8.png

    Another Way:

    If you don't want to create report and show total value in table view, you can create one record on form firstly, the new row can be shown in the table view.

    For automatic calculation of totals, you can try using rollup column to achieve this if you wish, please refer to the following steps.

    (1) Create 1:N relationship between this table and itself.

    pastedimage1677722640476v1.png

    (2) Create two columns that behavior is rollup and edit:

    pastedimage1677722879418v2.pngpastedimage1677723055842v3.png

    pastedimage1677723444499v4.pngpastedimage1677723466035v5.png

    (3)Add these fields to form and publish.

    (4)Test:

    --Create one new record named with Grand Total:

    pastedimage1677725698134v9.png

    --Update existing records, use new created record as parent depratment:

    pastedimage1677725737960v10.png

    --

    pastedimage1677725853046v11.png

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 > Service | Customer Service, Contact Center, Field Service, Guides

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 32

#2
ManoVerse Profile Picture

ManoVerse 31 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 31 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans