Forum Discussion

THZR_1's avatar
THZR_1
New Member
2 years ago

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 - ...
Need Help
THZR_1's avatar
THZR_1
New Member
2 years ago

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's avatar
    Tom_Y
    Icon for Advocate II rankAdvocate II
    2 years ago
    Add a New Column

     

    something like

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