Скачать или смотреть LINQ | LINQ Pivot Table Aggregation | Sum LINQ Pivot | LINQ Uipath | Uipath Tutorials | Coderslobby

LINQ | LINQ Pivot Table | Sum Using LINQ Pivot | Count Using LINQ Pivot | Aggregation Methods in LINQ Pivot | LINQ Uipath | Uipath Tutorials | Coderslobby
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

Code:- Query

dtResult - (From row in dtTest.AsEnumerable
Group row By Key = New With{
Key.Region = row("Region").ToString,
Key.Item = row("Item").ToString
}into grp = Group
Select dtResult.LoadDataRow(New Object(){
Key.Region,
Key.Item,
grp.Sum(Function(y) Convert.ToDouble(y("Units").ToString)),
grp.Count
},True)).OrderBy(Function(x) x("Region").ToString).CopyToDatatable

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

🎧In this video tutorial, you will learn
Different Aggregation methods using linq pivot?

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

🖥️Video Summary 👉
In video will learn how find the sum and count using linq pivot.
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

Hope you found this video useful. Please like, share the video, and subscribe to our channel. This will motivate us to create more good content. Thanks!

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

🎧Do watch our Other Videos 👉
Uipath👉    • UiPath Tutorials  
Uipath LINQ👉    • Linq Uipath  
VBA👉    • VBA Tutorials  
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

-------------------------------SOCIAL-------------------------------
🛠️ If you have any doubt or query, drop us an email: [email protected]
👥Facebook: https://fb.me/CodersLobby
📸Instagram:   / coderslobby  
📱WhatsApp: 8558919766
----------------------------------------------------------------------