2). Go to Insert Menu >> Calculated Column. Use the expression -> Sum([Sales]) OVER ([Customer_Name]) - Sum([Sales]) OVER (Next([Customer_Name])) .
Below is the screen-shot of the final table.
Note that a sample analysis file "Difference.dxp" has been attached to this Knowledge Base article.