Count product by value list per week

[jade]

Hi, could someone help me in counting the product by value list per week found? I want the result would be like this:

[vinieme12 · Accepted solution]

Load  Valuelist,Product,DateFound,Week(DateFound) as ProductWeek

From XyzSource;

Then use a Pivot table

RowDimensions: Valuelist,Product

ColumnDimension: ProductWeek

Measure: Count(Product)

[anat]

Load  Valuelist,

Product,

DateFound,

'products in week'&Week(DateFound) as ProductWeek

From source