If condition Problem

[dathathreya]

Hi all,

I was struck with an senario of if condition .Please help me out.

i have a table like ID,ledger code,Subledger1,Subledger2

Here ID and Ledger code is unique.But Subledger1 and 2 in not.wat my requirement is

ID,ledger code,Subledger1,Subledger2

101,4041,LG/mg/00001,0

101,4041,40432,0

I want to show only the LG/mg/00001 row the below one should be hide..

These are dimensions .Subledger1,Subledger2 only.Only for 2 id;s i have to hide in my table remainig all are unique.

[Anil_Babu_Samineni]

May be use expression like FirstSortedValue(Subledger1, ID)

[dathathreya]

Firssorted value will work on expression i think while i am using this it is showing error.

[pradosh_thakur]

why not use

where Subledger1='LG/mg/00001'

[Anil_Babu_Samineni]

What error you are facing using that? Does all fields from same table?

[vinieme12]

if you only want to show Text values in Subledger1 then use IsText()

=if(isText(Subledger1),Subledger1)  and check supress null values on this dimension