Sum

[Canadiansal]

I have a list that has a Category Field and a Count Field

There will be 5 Categories in the List.

I will like to create a Summary Screen in the APP, where the Count of Each Category is Displayed.

So:

Cat1: Total

Cat2: Total -etc.

[eka24]

Insert a Gallery and on the Items Property put:

AddColumns(GroupBy(MyList,"CategoryField","GroupedColumn"),"CountColumn",CountRows(GroupedColumn))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

[Canadiansal]

Does not work 

AddColumns(GroupBy(Compete,"Team","YourPts"),"CountFunction",CountRows(YourPts))

[eka24]

Is complete the name of your Table and Team the name of tour column?

If you have errors can you show a screen shot?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

[Canadiansal]

Thanks. Here is the Table. Team is a Choice Column. And YourPts is a Numerical score.

I am trying to create a leaderboard which will show the Points grouped by Team,

[v-qiaqi-msft · Accepted solution]

Hi @Canadiansal,

Based on the issue that you mentioned, do you want to sum the scores of each grouped team?

Could you please share a bit more about the scenario?

I have a test on my side, please take a try as below.

In my scenario, I have the SPList1 as my data source, a Choice column Team and a Number column YourPts.

Add a Gallery and set the Items property as below:

AddColumns(
    GroupBy(
        AddColumns(
            SPList1,
            "NTeam",
            Team.Value
        ),
        "NTeam",
        "GTeam"
    ),
    "SumPts",
    Sum(
        ForAll(
            GTeam.YourPts,
            YourPts
        ),
        Value
    )
)

Set the Text property of the Labels within the Gallery as below:

ThisItem.SumPts

Regards,

Qi