Inserting Summation Rows in Power Query

Copper Contributor

I am using Office 2019 and i want to add a summation row after every last unique ref "GRV" and also the cell below the last unique reference "GRV', i want to sum totals of Columns "Tpt Charge","Offloading Fee" & "Tollgate Fee". How do i do that?

1 Reply
I'd create a pivottable from the result of the PowerQuery table