Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Display Top3 capital values in the graph with respective values and other values as "others"

Hi All,
I have 6 values in segment column(A,B,C,D,E,F,G).
My requirement is to display the capital for top 3(lets say A,B,C) segments in the bar graph and for the other 3 segments(E,F,G) I should display the capital as one value.
I am able to display the top3 segments capital in the graph, can anyone please help me how would I display the capital for other 3 segments together as "others" as shown in the graph below?
Vertical axis - Capital
Horizontal axis - Year
Thanks,
Vijaya
Answers
-
This blog should help you to get your top 3 + other combined report ready.
0 -
Hi Arijit,
Thank you, that helped.
When I create a stacked graph based on the pivot table after following the above link, the segment column is not displaying all the values(4values) in the graph which is taking only one random value and displaying for given years. Any Idea what could be the reason?
Thanks,
Vijaya
0 -
Hello Vijaya,
Try below approach
Step 1
4 column in the criteria
Column1
Rank(sum(yourmeasurecolumn))
column2
Yoursegmentcolumn
column3
yoursegmentcolumn(again)
column4
sum(yourmeasurecolumn)
Column5
YourYearColumn
Have a filter for column1(ie yourrankcolumn) <=3
Step 2
add a combine similar request and paste the same criteria as the second criteria
Edit column2 and keep 'Others' in the column formula
change the filter to column1>3
create a pivot view and exclude the column3(ie yoursegment column)
Pivot Structure
Rows
Year Column
Columns
YourSegmentColumn
Measures
Your MeasureColumn
Excluded
Rank and Column2(yoursegmentcolumnwithout others)
create a chart from the pivot and hide the pivot from views.
done !
0 -
It worked.Thank you Asim Cholas.
0