Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is only() function how it works?please give one example friends.
check this thread i think its helpful Use of ONLY Function
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
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.
hi,
did u chk dis?
When in dimension(column) all values are
the same ,Only will return this value:
(otherwise NULL)