Display Top3 capital values in the graph with respective values and other values as "others" — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Display Top3 capital values in the graph with respective values and other values as "others"

Received Response
11
Views
4
Comments
3545306
3545306 Rank 3 - Community Apprentice

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?

pastedImage_2.png

Vertical axis - Capital

Horizontal axis - Year

Thanks,

Vijaya

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    This blog should help you to get your top 3 + other combined report ready.

    https://www.rittmanmead.com/blog/2010/09/oracle-bi-ee-11g-filters-selection-steps-top-n-products-case-study/

  • 3545306
    3545306 Rank 3 - Community Apprentice

    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

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    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 !

    pastedImage_0.png

    pastedImage_1.png

  • 3545306
    3545306 Rank 3 - Community Apprentice

    It worked.Thank you Asim Cholas.