Cumulative total while grouping

[ErsinALACA]

Hi; While browsing the Internet, I encountered a file with the following codes. Creating an Index; during grouping. Can we improve this process? I tried, I couldn't. Can we get a cumulative total for Nb Items (line by line)?

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Supplier", type text}, {"Item", type text}, {"Nb Item", Int64.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Supplier", Order.Ascending}, {"Nb Item", Order.Descending}}),
    #"Group by Supplier" = Table.Group(#"Sorted Rows", {"Supplier"}, {{"Partition", each Table.AddIndexColumn(_, "Rank", 1,1), type table}}),
    #"Expanded Partition" = Table.ExpandTableColumn(#"Group by Supplier", "Partition", {"Item", "Nb Item", "Rank"}, {"Item", "Nb Item", "Rank"})
in
     #"Expanded Partition"

Thanks in advance.

 

[sandy666]

use XL2BB to post a data table(s) not a picture

 

[ErsinALACA]

Table1				Rank_nbItems_per_Supplier
Supplier	Item	Nb Item		Supplier	Item	Nb Item	Rank
Tim	Car	12		John	Computer	15	1
Tim	Tv	5		John	Tv	5	2
Tim	Mobile phone	22		John	Mobile phone	2	3
John	Car	1		John	Car	1	4
John	Tv	5		Michael	Mobile phone	22	1
John	Mobile phone	2		Michael	Car	15	2
John	Computer	15		Michael	Computer	7	3
Michael	Car	15		Michael	Tv	2	4
Michael	Tv	2		Tim	Mobile phone	22	1
Michael	Computer	7		Tim	Car	12	2
Michael	Mobile phone	22		Tim	Tv	5	3

I was looking for this XL2BB

 

[sandy666]

here is step-by-step

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Supplier", type text}, {"Item", type text}, {"Nb Item", Int64.Type}}),
    Sort = Table.Sort(Type,{{"Supplier", Order.Ascending}, {"Nb Item", Order.Descending}}),
    Group = Table.Group(Sort, {"Supplier"}, {{"Count", each _, type table}}),
    Expand = Table.ExpandTableColumn(Group, "Count", {"Item", "Nb Item"}, {"Item", "Nb Item"}),
    Index0 = Table.AddIndexColumn(Expand, "Index", 0, 1),
    Mod = Table.TransformColumns(Index0, {{"Index", each Number.Mod(_, 4), type number}}),
    Add1 = Table.TransformColumns(Mod, {{"Index", each _ + 1, type number}})
in
    Add1