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