1. NOTICE: If you are using Fabrik and update to Joomla 3.10, you will need to update to Fabrik 3.10. And, if you are using Fabrik, do not upgrade to Joomla 4, we do not have a supported version ready for release. More information on a release date coming soon. Also, please note that Fabrik 3.10 will not install on any Joomla sites less than 3.8.
    Dismiss Notice

Sum of numeric element in list divided by groups

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

  1. enrb

    enrb Member

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

    troester Well-Known Member Staff Member

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

    Gesendet von meinem SM-G930F mit Tapatalk
     
  3. enrb

    enrb Member

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

Share This Page