This discussion is archived
0 Replies Latest reply: Sep 5, 2012 9:46 AM by 951381 RSS

Displaying "Top N and Other" in Pie Chart

951381 Newbie
Currently Being Moderated
Hello All,

As the subject implies, we are trying to display in pie charr top 5 products by sales and bucket rest of the product sales in "Others". Oracle provided documentation gives below code. But I am not sure as how we can package this in view which can be used in chart


RETURN "Top5Companies" AS SELECT
"coName" AS "companyName",
SUM("txnID") AS "numTxn"
GROUP BY "coName"
ORDER BY "numTxn" DESC
PAGE(0,5)
;
RETURN "Others" AS SELECT
'Others' AS "companyName",
SUM("txnID") AS "numTxn"
WHERE NOT ["coName"] IN "Top5Companies"
GROUP

Edited by: 948378 on Sep 5, 2012 9:46 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points