error with Table.Group

[reynaldo_malave]

Hi guys, 

I have a table that i want to group by multiple features. The correct nswer should be forty but instead is giving 320. I leave the images below.

BeforeTable.Group

After Table.Group

Any help would be greatly appreciated

Rey

[Anonymous]

Try changing the List.Sum to List.Count. 

[ziying35]

Hi, @reynaldo_malave 

I don't get it, do you mean that the column you marked on the screenshot, automatically split into group when their values sum to 40 each time?

[lbendlin]

Please provide sample data in usable format.