SumX in table

mahoneypat 

Hi Mahoney -  Thanks for the help but still not quite there.   I had also thought that would be a solution and have tried it.  

On this particular visual, I will always have an RMA #  (sort of like an incident ID number).     You can see what the NewMeasure is doing is summing up the totals of all the RMA items  (the actual products being returned).     I've created a small separate table to show that on the far right.    

Perhaps what is needed is a formula that says "per a particular RMA number, show me the sum values for that...but at the row level".    I had thought the SumX formula would do that anyways, but it is still showing an aggregrate of total qty to return for ALL of the items.    Not just the ones associated with a given row.  

For example, what I expect is: 

RMA #           RMA Item        Qty to Return    Unit Cost    Total Cost

RMA-001         A45343                   4                   .25              1.00

RMA-003         12345                     3                   .50               1.50

RMA-003         234AB                    1                   2.25             2.25    

(note that one RMA incident can have multiple items associated with it)