You’re offline. This is a read only version of the page.
38
Hi,
I have a table with the following structure,
Name | Project | January
Silvia | Project 1 | 0.3
Silvia | Project 2 | 0.7
Silvia | Project 2 | 0.3
Ruben | Project 2 | 1
Is it possible to create a view in model driven apps where I can get the users that the sum for each month in the project is not equal to 1?
In this situation the output should be, Silvia in Project 1.
Thank you,
Ruben
In addition to @MarioRing's answer, you may use a custom PCF grid control to show the SUM of the column. But still, you cannot group by the user + month, so you will have to filter.
https://pcf.gallery/aggregate-grid/
Another option is to add a custom page to your model-driven app on which you can show the data table of the collection after Group By And Find The SUM using Power Fx.
Hi,
To achieve your goal your table should look like this:
| Name | Project | Month | Sum of Allocation |
| Silvia | Project 1 | January | 0.3 |
| Silvia | Project 2 | January | 1 |
| Ruben | Project 2 | January | 1 |
And then of course add a filter (Sum of Allocation != 1).
Unfortunately, this combination of aggregation and filtering is not available for the views.
However, you can create a table of that structure and write an automation that generates calculated insights of your data.
I recommend you to adjust your table data structure by adding the column "Month" instead of "January" (then "February" and so on...), like:
| Name | Project | Month | Allocation |
| Silvia | Project 1 | JAN | 0.3 |
| Silvia | Project 2 | JAN | 0.7 |
| Silvia | Project 2 | JAN | 0.3 |
| Ruben | Project 2 | JAN | 1 |
Then you can use the Excel template or Power Bi report to generate Pivot Table that aggregates your data. You can also add a conditional highlight:
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
