Help please to group & average some data

[markdmac]

I have a report in a CSV file that lists Cost Center, Mobile Number, Mobile Number User Name and Domestic KBU. The data represents several months of usage for each user.

I need to generate a report where all Mobile Numbers are grouped by Cost Center, I would like each number to appear only once with calculated field to list the highest Domestic KBU (for just that user) and the average data usage for that user.

Here is what I have so far to group by the cost center. I'm unsure how to continue my sorting to get the details for the specific users.

$VZW = Import-CSV "C:\Users\mmaclach\Desktop\Martin.CSV" | Select "Cost Center","Mobile Number", "Mobile Number User Name", "Domestic KBU" | FT -GroupBy "Cost Center"
$VZW

Any guidance or suggestions would be appreciated.

 

[GrimR]

something like this?

http://technet.microsoft.com/en-us/library/ff730946.aspx

MCSE NT to 2012, MCITP:EA/SA, MCSA, MCDBA, MCTS, MCP+I, MCP