Group by or Filter sum rows

[KH11NDR]

Hi Guys,

I need these columns

ID&Product	Total Days
111Books	15
111Cars	15
111Bike	20
222Bike	55
222Cars	75

from this table

ID	Product	ID&Product	Days
111	Books	111Books	5
111	Books	111Books	10
111	Cars	111Cars	15
111	Bike	111Bike	20
222	Bike	222Bike	25
222	Bike	222Bike	30
222	Cars	222Cars	35
222	Cars	222Cars	40

Thanks

[KH11NDR · Accepted solution]

Sorted, using real data

Test = if(DeliveryExtract[Week Number] = DeliveryExtract[Week From],SUMX(VALUES(DeliveryExtract[ProjectID & Product Key]),CALCULATE(SUM(DeliveryExtract[Actual Time + ETC (Days)]))))