once again i am asking here… i Have one simple report: only three columns
airline names and amount and others
here i calulated others based upon below formula its working fine…
=NoFilter([Sum amount])-Sum([Amount])
but i want show in graph… i am unable show others in my graph
in my graph 3 columns one is airline names and amount and others also
i verified in fBOB forum also …
bo_cherry - replace a, b, c with your state names eg New York, LA etc. In other words defined the ones you want to include and then the rest become “Others”
thanks for your reply i tried its not working… its showin only airlinename and amount, others its not diplaying here…
i need top 5 airlines and amount and also othersairline amount also… very use…doc (67.0 KB)
bo_cherry, are the top 5 airlines dynamic ie do they change each month or each time you run the report or are they static ie the top 5 are always the top 5?
yes its top 5 airlines dynamic only, it will change when data change( normally each time when i run the report). steve here i want only one thing i am not able to show others ( amount) in my graph.
in my report now top 5 airlines and amount showing perfetly, but one thing missing others amount . i want show others amount also in my graph. i am able to show others in my table report … but in graph its not displaying others column…
Bo_cherry, this is a tough one. If the top 5 were static it would be simple. Ive had a play with eFashion my approach was (using State and Sales Revenue as my objects) to use the Rank Function in a variable and group the values based on what there rank is eg If rank is less than 6 then give me the State name otherwise give me the word Other. However, the issue seems to be I cant force the context of the rank calculation without having the dimension (State in this case) object present in the final chart or table. So it gives me the word Other only with the State object in the block. Its possible someone with a bit more input/output webi context experience than me may be able to crack this (but I better do some real work! )
So you will need to try using database ranking possibly via a derived table or view in the universe. Or a new approach eg maybe dont have a chart but use the table and the nofilter function like you already have.
WHat is the criteria for definig “Other”.
I saw the defnition of other in your first post to be a difference of NOFILTER(). What is the filter here?
If there is a filter in the report and your object defnition for “Other” is a filter override obviously “Other” wont come up in the report. Remove the filter, you should see “Other”
but i have any small issue airline name showing Twice is there any option
to avoid only one Name in my graph airlinename and new_airline and amount
in new-airline variable i have implementd other formula
i want to show in graph only new_airlien and amount some what i have to hide the airlinenames, but in my grapth bothairlinename showing( like: Usairline/Usairline)
Can you tell me how you have successfully implemented “Others” in your graph? I am having the same issue with #multivalue and have not figured out how to fix it in my graph.
(BOB member since 2008-07-09)
)
(BOB member since 2004-08-27)
(BOB member since 2005-02-24)
With respect, have you read the thread 
(BOB member since 2009-02-18)
(BOB member since 2009-08-03)