How to filter 1 column based another when creating a chart?

[#1]

Sorry for the basic questions - I am really new to Qlikview...

I have a dataset which includes fields similar to the ones below.  I want to create a table that shows the the sum of the calculated column, but only where Text = 'A'

Could anyone suggest a good way of doing this?

Text	Calculation
A	=if(Sum(X)=0,null, Sum(X)/Sum(y)
A	=if(Sum(X)=0,null, Sum(X)/Sum(y)
B	=if(Sum(X)=0,null, Sum(X)/Sum(y)

[sushil353]

try this:

sum({<Text={'A'}>}X)