Skip to Content
author's profile photo Former Member
Former Member

Display top 5 data in pie chart.

Hi,

a)I have 2 columns

1. Branch - has 10 column

2. Sales revenue

I have to display top 5 sales data for the branch in pie chart. The remaining 5 datas legend should be shown as "others" in the same pie chart. Can you tell me the steps

b) I have a pie chart-A with aggregated data which has 4 region of sales data. Have other pie chart-B with detailed data.

*pie chart-A*

Region sales

East 35344

West 6565

North 87489

South 35736

Pie chart- B

Region Branch sales

East A 848

East B 573

East C 235

West D 854

West E 632

West F 682

If i click East region, the branch details should be displayed in seperate pie chart.

In pie-chart A, if i click "Drill down" option-> the insertion type i clicked is "Row", when moved to pie chart-B it doesnot allow me to take 3 rows at the same time'

(eg: s

East A 848

East B 573

East C 235).

Note: I need to display all the 3 rows of data in pie chart. Need to know what type of insertion type to select multiple rows.

Thanks,

Abi

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2011 at 10:55 AM

    Hi,

    Hope this article would be helpful to you.

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/60bba2a2-9053-2e10-fb90-dd71175e0fda

    Regrads,

    Anju Saseendran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2011 at 01:47 PM

    In that PDF, I can see only top 5 data. the remaining 7 datas should be shown as others in pie- chart?. Is iit possible.The legends should also be changed.

    Can we tell me how to include attachements ?

    Regards,

    Abirami.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.