How to do Column1=Column2 in set Analysis

[agni_gold]

I am tring to write below expression , but it is npt working

=aggr(sum({<[Account Type]={"=[Entry Type]"}>}[ERP Amount])/1000000,[PL Parent Description])

[sunny_talwar]

Not sure if this will get you what you want, but try this:

=Aggr(Sum({<[ERP Amount] = {"=[Account Type]=[Entry Type]"}>}[ERP Amount])/1000000,[PL Parent Description])

[agni_gold]

I just want

select sum(Amount) from table1 , table2

where table1.Account_Type=table2.Entry_Type

for this sql query I have written above set expression.

[sunny_talwar]

Would you be able to share a sample?

[robert_mika]

Are you using this set on two tables in front end?

Are they already join or are they two loosely couple tables?

[MK_QSL]

little change... try this..

=SUM(Aggr(Sum({<[ERP Amount] = {"=[Account Type]=[Entry Type]"}>}[ERP Amount])/1000000,[PL Parent Description]))

[sasiparupudi1]

Please post your application