Calculation

[Jyo27]

Hi Everyone . I need help regarding calculation .How to calculate total quantity per category per week ?Appreciate your help. Below is the chart for your reference.

[Jyo27]

[FreemanZ · Accepted solution]

1) You need a date table with two columns: Date and Weeknumber. 

2) Connect two Date Columns from two tables. 

3) Then plot a Matrix visual, put Weeknumber to Columns, Category to Rows, Total quantity to Values.

[Jyo27]

Thank you .Got it.

[Jyo27]

Lets say A category has total quantity of 2 in week 13 , 3 in week 12 and so on .

[FreemanZ]

How does your raw data look like?

[Jyo27]

Yes this the expected result .Need to calculate total quantity per week 

[FreemanZ]

Is it the expected result? How does your raw data look like?