Forum Discussion

Draginko's avatar
Draginko
Helper I
3 years ago
Solved

Table.Group to aggregate values based on another column's value

I am grouping multiple columns, and in some I will have grouping based on some condition. Trying to figure one first, with the name "Sum of EMP FTE", but I am somehow not able to figure out the corre...
Need Help
Tips and Tricks
  • Draginko's avatar
    Draginko
    3 years ago

    Oh okay, got it...this one seems to be working:

                {"Sum of EMP FTE", each 
                Number.Round(
                    List.Sum(
                        Table.SelectRows( _, each [e.Cat] = "EMP" )[FTE]
                    ), 0
                ), type number
            },

    Many thanks for your help Anonymous ðŸ™‚

Anonymous's avatar
Anonymous
Not applicable
3 years ago

sorry my mistake.  Table.SelectRows is required.

Draginko's avatar
Draginko
Helper I
3 years ago

Oh okay, got it...this one seems to be working:

            {"Sum of EMP FTE", each 
                Number.Round(
                    List.Sum(
                        Table.SelectRows( _, each [e.Cat] = "EMP" )[FTE]
                    ), 0
                ), type number
            },

Many thanks for your help Anonymous ðŸ™‚