praveen raju
Sep 10, 2020Copper Contributor
Query to find count and sum
Here is my data-table Looks like.........
Category Annual savings
------- ------------------
Category-1. 1
Category-2. 3
Category-1 5
Category-1 6
Category-3 1
Category-3 9
I Need a power-shell query to get the output as following
Category Sum(savings) Count (Category)
------- ------------------ -----------
Category-1 12 3
Category-2 3 1
Category-3 10 2
Quick help will be appreciated.