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
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:
--Add these two column with 'Sum' type when you configure the report:
--Run report:
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.
(2) Create two columns that behavior is rollup and edit:
(3)Add these fields to form and publish.
(4)Test:
--Create one new record named with Grand Total:
--Update existing records, use new created record as parent depratment:
--
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
