Subtract by values

[jaimeoconor]

Hi,

I have, for example, the following data:

Asset   Performance 

Asset 1     5%

Asset 2     3%

Asset 3     8%

Asset 4     10%

I would like to create a table showing every Asset and the result of Asset x Performance - Asset 1 Performance. The result should be the following:

Asset 1  0%

Asset 2  -2%

Asset 3  3%

Asset 4   5%

I wrote Sum([Performance])-sum({<Asset={'Asset 1'}>}[Performance]) and, as a result, only Asset 1 is being subtracted.

Many thanks in advance 

[Sue_Macaluso]

@jaimeoconor  Are you using Qlik View or Sense?  I would like to move this into the correct product forum.  This forum is typically for platform-related discussions.