Sum of numeric element in list divided by groups

[enrb]

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

 

[troester]

Use 'Split by', select your color element

Gesendet von meinem SM-G930F mit Tapatalk

 

[enrb]

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 ...