what is only() function how it works?

[#1]

what is only() function how it works?please give one example friends.

[Chanty4u]

chk dis

How To /Missing Manual (24 articles)

How to use - Only()

[Anonymous]

check this thread i think its helpful Use of ONLY Function

[#4]

Lke You want to see the sales of selected year, selected-1 year and selected+1.

For example i selected 2006 , so i want to see sales for 2006,2005 and 2007.

In this scenario , we can use only() function-

here is the script :

Sum({<Year={$(=Only(Year))}>}Sales) - 2006

Sum({<Year={$(=Only(Year)-1)}>}Sales)-2005

Sum({<Year={$(=Only(Year)+1)}>}Sales)-2007

[ajsjoshua]

Hi,

It returns only one  value or null incase multiple value returned.

ex:

country        city

india           Mumbai

India          chennai

india          delhi

only(country) means answer is india

only(city) means null.

Regards,

JOshua.

[Chanty4u]

hi,

did u chk dis?

How to use - Only()

When in dimension(column) all values are

the same ,Only will return this value:

                                        (otherwise NULL)