Forum Discussion
Difference in a Total
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?
3 Replies
Tom_YAdvocate II
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.
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_YAdd a New Column
something like
Differ = 'Table'[View 2]-'Table'[View 1]
