Sum of Costs associated with Item Issue

[ambventure]

I am struggling to set up a sum of Costs by Inspector. I've tried these and many others on the forums and youtube. I am happy to pay the person who can solve my problem $75 via PayPal. 

Current setup:

Dimension "QB" is =if (Match([Transactions.Item Type], 'ServiceItem', 'InventoryItem', 'InventoryAssemblyItem', 'NonInventoryItem', 'OtherChargeItem', 'DiscountItem') and Match([Transactions.Txn Type], 'Invoice'), [Transactions.Item Type]) 

Dimension "Item"  is Transactions.Item Full Name

Dimension "Type" is =if(([Transactions.Inventory Table] = 0) and (Transactions.Pending = 0 or IsNull(Transactions.Pending)) and Match([Transactions.Txn Type], 'Invoice','Sales Receipt', 'Credit Memo', 'Charge', 'ARRefundCreditCard'), [Transactions.Line Items Txn Type]) 

Expression "Fee" is sum([Item.Purchase Cost])  

I did this because I have no data on the transactions.cost field

This is what I've tried.

=Aggr(Sum(TOTAL<[Transactions.Class Name]>[Fee],[Transactions.Item Full Name],[Transactions.Class Name])) 

and all combinations thereof, I've pushed Dimensions to Expressions to see if one will help calculate the Fee column.

I don't know if this is a currency or amount issue, but the Transactions.Amount with Sign isn't populating any results.

I've tried the basic functions as well and i'm not sure how to get the total to add up correctly.

I appreciate any help!

[Kushal_Chawda]

@ambventure  what is the expected total?

[ambventure]

The total should be  370 instead of 150

My chart is trying to add up associated cost per item instead of a cost per invoice by Inspector.