Difference in a Total

[THZR_1]

I have a sheet below

View - ID - Order - Item - Weight

View 1 - 12345 - 1111 - 10 - 10

View 1 - 12345 - 1111 - 20 - 10

View 2 - 12345 - 1111 - 10 - 10

View 1 - 4567- 2222 - 10 - 10

View 1 - 4567 - 2222 - 20 - 10

View 2 - 4567- 2222 - 10 - 10

View 2 - 4567 - 2222 - 20 - 10

View 2 - 789- 3333 - 10 - 10

View 2 - 789 - 3333 - 20 - 10

And would like to create a Table which shows me as below. The View 1 and View 2 would be defined by a filter, but it could also be a View 3

Ex:

Filters (View 1, View 2) - but it could be View1, View3 or View2, View5 and so on..

ID - View 1 - View 2 Total

12345- 20 - 10 - (-10)

4567 - 20 - 20 - 0

789 - 0 - 20 - 20

Does anyone know how to solve this?

[THZR_1]

Tom,

I need the total to show the Diference between View 1 and View 2. 

(Value View 2 - Value View 1)

In the case your post, the total should be:

Total

30

0

-20

10

Appreciate the help

[Tom_Y]

Add a New Column

something like

Differ = 'Table'[View 2]-'Table'[View 1]

[Tom_Y]

Use "Group By" in Query Editor.

Same as below.

In Matrix Visual, choose either New Item, New Weight, or both, and you will get it.