system
June 17, 2009, 3:35pm
1
Guys,
I want to create a variable that will show me top 5 state base on loan balance then verything else will fall into other. Is there a solution for this? please advice!
kyanforum (BOB member since 2009-05-22)
system
June 17, 2009, 3:48pm
2
Hi,
This may help:
I need to create a PIE graph with OTHERS for a WEBI report.
I have 3 columns on the report
Student Roll No, Student Name, Total Marks
I need to display only the the Top 5 Student Names on the basis of Total Marks all others need to be displayed under OTHERS.
This needs to be displayed in a Pie Chart. I have a primary Key in the table “Roll No” which does not allow me to group on “Others”.
Please help!!! Can I create a Pie graph displaying only top 5 student names and the remaining students …
Hi everyone.
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 …
Does anyone know how to take a list and only show the top 10 values, and then roll up the remainder of the list into an “OTHER” category. The “Other” category should sum up all the data that wasnt in the top 10 list.
Thanks!
Next time please use search before posting a question. Thanks.
Marek Chladny (BOB member since 2003-11-27)
system
June 17, 2009, 5:38pm
3
I did the following
var 1: U State Rank
=Rank( ,)
Var 2: U Top 6 State
= If <6 Then Else “Other”
Then I get the Multi Value when I turn Var 2 into a measure object…please advice how to fix this
kyanforum (BOB member since 2009-05-22)
(BOB member since 2003-11-27)