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

Question

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

3545306 · Answer

It worked.Thank you Asim Cholas.

asim cholas · Answer

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 !

3545306 · Answer

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