BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Rank Questions


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 606
Location: USA



PostPosted: Fri Nov 05, 2010 2:49 pm 
Post subject: Rank Questions

How to display “Others” in country field based on Rank.
Initial Report:
Rank Country Sales$$
1 USA 450K
2 CANADA 340K
3 ENGLAND 200K
4 INDIA 125K
5 BRAZIL 100K

New Requirement (Top 3 and Others)

Country Sales$$
USA 450K
CANADA 340K
ENGLAND 200K
Others 225K
Back to top
cpmohanraj
Forum Associate
Forum Associate



Joined: 23 Sep 2002

Posts: 720
Location: Perth, Australia


flag
PostPosted: Sun Nov 07, 2010 8:33 pm 
Post subject: Re: Rank Questions

You can add it as part of the Footer. The function can be done using NoFilter().

Am just giving you the pointers, I guess you should be able to take t up from there.

_________________
Mohanraj CP
Perth, Australia
http://blog.mohanraj.org
Back to top
hbanerjee
Forum Member
Forum Member



Joined: 16 Aug 2010

Posts: 18


flag
PostPosted: Mon Nov 08, 2010 1:50 am 
Post subject: Re: Rank Questions

cp -- your feedback was very helpful. I tried it and it works as expected. Seems so simple but I was struggling with it for 2 days.

Now my only challenge is - How do I display others in the pie chart as well.

Hemanta Banerjee
http://howtobi.wordpress.com
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 606
Location: USA



PostPosted: Mon Nov 08, 2010 2:44 pm 
Post subject: Re: Rank Questions

Hi hb,
How do you performed this? Could you please share your knowlege on it? My requirement is exactly same as yours. I need to create a chart based on this data (with others and rest three)
Back to top
vijay2817
Forum Member
Forum Member



Joined: 28 Oct 2010

Posts: 26



PostPosted: Mon Nov 22, 2010 5:16 am 
Post subject: Re: Rank Questions

Hi,

You could use
=NoFilter(([Revenue])-Sum([Revenue])) in the footer.
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 606
Location: USA



PostPosted: Mon Nov 22, 2010 2:43 pm 
Post subject: Re: Rank Questions

Thanks Vijay. But how you display 'Others' in pie chart?
Back to top
M H Mohammed
Forum Associate
Forum Associate



Joined: 16 Jun 2010
ASUG Icon
Posts: 842
Location: New York, NY


flag
PostPosted: Mon Nov 22, 2010 3:26 pm 
Post subject: Re: Rank Questions

Hi,

I had the issue of showing the Others measure in a Chart, but I didn't find out a way to do that.

Any help will be appreciated.

Thanks,
Mohammed Hussain
Back to top
vijay2817
Forum Member
Forum Member



Joined: 28 Oct 2010

Posts: 26



PostPosted: Tue Nov 23, 2010 12:25 am 
Post subject: Re: Rank Questions

Hi Philip,

After applying the Formula in the footer, Right Click the Table and Click "Turn-To" and select Pie Chart.

You'll get it..


Thanks and Regards,

Vijay
Back to top
vijay2817
Forum Member
Forum Member



Joined: 28 Oct 2010

Posts: 26



PostPosted: Tue Nov 23, 2010 1:03 am 
Post subject: Re: Rank Questions

Hi Philip,Hussain

The following link might help you..

http://www.forumtopics.com/busobj/viewtopic.php?t=125921&highlight=ranking


Regards,

Vijay
Back to top
akl007
Senior Member
Senior Member



Joined: 23 Mar 2010

Posts: 97



PostPosted: Tue Nov 23, 2010 1:38 am 
Post subject: Re: Rank Questions

vijay2817 wrote:
Hi Philip,

After applying the Formula in the footer, Right Click the Table and Click "Turn-To" and select Pie Chart.

You'll get it..


Thanks and Regards,

Vijay


This will not work. The others won't come in Pie Chart.
Back to top
Dirasa
Senior Member
Senior Member



Joined: 12 May 2008

Posts: 55


flag
PostPosted: Tue Nov 23, 2010 2:02 am 
Post subject: Re: Rank Questions

Hi Philip,

Create a new object in universe , and write a case statement like below one.

Case when rank() ... <=3 then <Name> Else "Others" end

Syntax may not be appropriate, but structure is same.

Use the above created object in the report and now turn to pie chart. icon_smile.gif

Regards,
Dirasa
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0284 seconds using 17 queries. (SQL 0.0020 Parse 0.0009 Other 0.0255)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo