only function

[prabhas277]

hi to all,

i have one list box called as Names. now my aim is i want get only one value in the in the chart..i am trying like this but i cant get it

Only({<Name='1-Rock Roll'>})  give me what is the correct synario..

regards

suresh

[tresesco]

In the chart dimension, take the filed Names, and in the expression use set analysis like:

Sum({<Name='1-Rock Roll'>} Amount)

[its_anandrjs]

Hi,

Try this ways

Only({<Name='1-Rock Roll'>} [Field Name Here] )

In bold use field name at least there.

Regards

Anand

[Anonymous]

use if you want to do it in list box you can use expression

if (Name='1-Rock Roll',Name)

if you want to sum in chart for one name you can use calculated dimension and use above expression.

and in expression use sum(sales)

Thanks

BKC

[robert_mika]

If you need to know how to use  Only

How to use - Only()

[jagan]

Hi,

Try like this

=Only({<Name={'1-Rock Roll'}>} Name)

Hope it helps you.

Regards,

Jagan.

[nagarjuna_kotha]

Hi,

Try this>>>

Only({<Name='Rock Roll'>}) 

Regards,

Nagarjuna