How to get count of matching columns in straight table

[#1]

Hi I created a straight table like this

x y

1 1

1 2

2 5

2 2

I want to count where x and y have equal values . I want to compare only straight table data not entire data.

Please help

[tresesco]

In the straight table take an expression like: =Count(Total If(x=y,x))

[MayilVahanan]

HI

In load, Try like this

Load If(x=y, 1) as Flag from tablename;

Then in expression

Count({<Flag = {1}>} x)

[antoniotiman]

See attachment  

Regards

[#5]

Hi,

Try this Expression

=Sum(Total if(x=y,1,0))

Regards,

Vivek