Power Query Sum within grouped data

Hello,
Work book attached with examples.

I'm trying to sum figures in grouped data for each group, so I have the groped data ;

Please Login or Register  to view this content.

and I wan to sum a 'sales' column within the group, so if I were adding an index to to each grouping i'd put this after each ;

Please Login or Register  to view this content.

So I'd like to use list.sum in a similar way, but can't get it to work,

each _ List.Sum( [Sales] ) }} ) , List.Sum( _ [Sales] ) etc. don't seem to work.


i've exapneded one group and done the calculation on that group as I thought I might be able to make it a function, but couldn't get it right;

Please Login or Register  to view this content.

So I've like to get what i have for a single group, above, for each of the All Rows grouping,

Richard.

Thanks,
I'll have to work on this a bit,

Richard.

Originally Posted by Bo_Ry

Pure guess

PHP Code: 

let
    Source = Excel.CurrentWorkbook(){[Name="Cttest"]}[Content],
    Group = Table.Group(Source,"Day",{{"Sale",each List.Sum([Sales])},{"Sales%", each List.Sum([Sales])/List.Sum(Source[Sales]) }},0,(b,e)=>Number.From(Text.Length(e)>2))
in
    Group 


I'm not sure what the function is doing? (b,e)=> , The prior grouping is sort of what I had , giving a percent of Groupe sales to overall,
What I was trying to do was get a percentage, of each sale % within the group so AM / (AM +PM) and PM / (AM +PM) and so on for each days grouping.

Richard

Thanks for the link,

Richard.