I have a list <T>
within which i have four fields
Code - string
ProductGroup string
Price - decimal
BusinessDate - datetime
I need to Group by ProductGroup, and BusinessDate ( just the month and year part)
Meaning all dates in a month are grouped, and I need to sum the Price to give me a new list
T1
with
ProductGroup
BusDate ( this would hold just 01/MM/YYYY)
Price (sum of all prices in that month
Open in new window