Ranking Variable

[system]

Hi,

This may help:

120×120 10.4 KB

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 …

120×120 10.4 KB

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 … could anyone tell me proper solution please… please find attached document co…

120×120 10.4 KB

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! jman31679 (BOB member since 2007-07-20)

Next time please use search before posting a question. Thanks.

---

Marek Chladny (BOB member since 2003-11-27)