# Sum of numeric element in list divided by groups

Discussion in 'Community' started by enrb, Dec 15, 2021.

1. ### enrbMember

Level: Community
Sum of numeric element in list divided by groups

Good morning,
I saw that it is possible to enable (for the elements that allow it) the sum of the column in list view settings -> calculations

Is it possible to enable the sum also for grouped elements?

For example, if I have entered several items of clothing in a list and for each of them I have the color element, can I group the items of clothing by color in the list and have the total sum per group?

List Example:

TYPE - COLOR - Quantity
T-Shirt A - Red - 1
T-Shirt A - White - 2
T-Shirt A - Black - 4
T-Shirt B - Red - 5
T-Shirt B - White - 8
T-Shirt B - Black - 3
T-Shirt C - Red - 7
T-Shirt C - White - 7
T-Shirt C - Black - 8

I wish I could have a list grouped by colors with totals by color, so my list should become:

TYPE - COLOR - Quantity
T-Shirt A - Red - 1
T-Shirt B - Red - 5
T-Shirt C - Red - 7
Total - Red - 13

T-Shirt A - White - 2
T-Shirt B - White - 8
T-Shirt C - White - 7
Total - White - 17

T-Shirt A - Black - 4
T-Shirt B - Black - 3
T-Shirt C - Black - 8
Total - Black - 17

2. ### troesterWell-Known MemberStaff Member

Level: Community
Use 'Split by', select your color element

Gesendet von meinem SM-G930F mit Tapatalk

3. ### enrbMember

Level: Community
I tried, but I get something like this:

TYPE - COLOR - Quantity
A T-SHIRT - Green - 4
Total - Green - 4
Total - Red - 13
Total - White - 17
Total - Black - 17

T-Shirt A - Red - 1
T-shirt B - Red - 5
T-Shirt C - Red - 7
Total - Green - 4
Total - Red - 13
Total - White - 17
Total - Black - 17

T-shirt A - White - 2
T-shirt B - White - 8
T-shirt C - White - 7
Total - Green - 4
Total - Red - 13
Total - White - 17
Total - Black - 17

T-shirt A - Black - 4
T-shirt B - Black - 3
C T-Shirt - Black - 8
Total - Green - 4
Total - Red - 13
Total - White - 17
Total - Black - 17

He practically repeats me all the totals at each split change ...