BusinessObjects Board

Derived variable

building reports desktopintelligence
#1

Hi

report is attached for the question to be more clear. Version 6.1 BO.

I want to group all the values in leadtype source (dimension) as “All Others” when the percent (measure) is less than 2, and display this in a Pie chart.

I am able to get this manually by Data—> variables-----> Leadtype Source—> group.
then I created Final variable inside which I made “All others” group which has all the lead types less than 2 which are InList( “Dealer/Distributor Referrals” , “Direct Mail” , “Magazines (Ads & PR)” , “Other MT” , “Other Web” , “PS Sales” , “Technical Support” , “Trade Show”).

How do I make this more generic instead of hardcoding the values??

Any help will be greatly appreciated.

Thanks

[Moderator Note: Removed attachment on cross-posted topic. - Dave Rathbun]

neha008 (BOB member since 2007-07-09)

#2

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

Original topic

Thanks.

Dave Rathbun :us: (BOB member since 2002-06-06)

#3

This question is a little different from what I posted last time.

Do I still need to continue in the same post…? I am a lilltle new to this forum.

Thanks

neha008 (BOB member since 2007-07-09)

#4

But since you are asking it in continuation of other post, you have to continue in original post.
Please click on the link for original topic to continue

.

haider :es: (BOB member since 2005-07-18)

#5

The question appeared to be the same, and there were already responses. If something is different, please provide the additional information in the other post so that people will realize there is new data to consider.

Closing this one, something I should have done earlier. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)