Filter a displayed column by another column

[wasimalrayes]

Hi

I have set a table as below, but i am looking to filter to only show a certain Name from a column that i have not displayed.

I.e. right now i have the table as

ID	Figure
HJA7	7
HJA8	2
HJA9	10
HJA10	20
HJA11	8
HJA12	-17
HJA13	-1
HJA14	8
HJA15	2

the source has the below columns 

NAME	ID	Figure
BMW	HJA7	7
VW	HJA8	2
Honda	HJA9	10
BMW	HJA10	20
VW	HJA11	8
Honda	HJA12	-17
BMW	HJA13	-1
VW	HJA14	8
Honda	HJA15	2

I want my table column ID to be filtered just to show NAME=BMW i.e. as below

ID	Figure
HJA7	7
HJA10	20
HJA13	-1

[Kushal_Chawda]

@wasimalrayes  try below expression

=sum({<Name={'BMW'}>}Figure)

[wasimalrayes]

Thanks

I am trying this under the SORTING TAB and adding an expression for the 

=sum({<NAME={'BMW'}>}[Figure])

But it does not filter out just the BMW in the table?