Right! Thanks.

>>Does this not work because I need to Groupby GoodsType.Description and TransactionType.Descriptiion and both have the same name.
>>Is there a away around this?
>>Or ... is this why you should always prefix your field names? :(
>>
>>

>>                var pBI = context.TransactionDetails.
>>                    GroupBy(t => new { t.Parcel.GoodsType.Description, t.TransactionHeader.TransactionType.Description }, (key, g) =>
>>                    new
>>                    {
>>                        Transaction = key.Description,
>>                        Goods = key.Description,
>>                        Weight = g.Select(t => t.Weight),
>>                        Amount = g.Select(x => x.Amount)
>>                    });
>>

>
>
>

>var pBI = context.TransactionDetails.
>					GroupBy(t => new { 
>					parcelDescription = t.Parcel.GoodsType.Description, 
>					transactionDescription = t.TransactionHeader.TransactionType.Description 
>					}, (key, g) =>
>					new
>					{
>						Transaction = key.parcelDescription,
>						Goods = key.transactionDescription,
>						Weight = g.Select(t => t.Weight),
>						Amount = g.Select(x => x.Amount)
>					});
>