how do i perform subtraction

[#1]

Find attached.

I wanna subtract but I tem and place in new item called Total1

[swuehl]

A little more details in your description would be helpful, it's pretty much unclear what you are trying to do here.

Maybe add something like this to calculate the difference between Inventory and Macs lines:

Concatenate (Final)

Load Dual ('Total1:',4) as Text,

  Year,

  Sum(If(No=26,Data))-Sum(If(No=36,Data)) as Data,

  7 as SORT

RESIDENT Final

where WildMatch(No, '*26*', '*36*') and Match(SORT,1,3,5)

Group By Year;