I
want to show pie chart look like below image.
Lets
see how to build this chart.
Step
1:
First
we need to find out Top 10 Customers by Sales. Right
click on Customer Name and create set as “Top 10
Customers”.
Step
2:
Now
we need to create one more set for Top 20 Customers. Right
click on Customer Name and create set as “Top 20
Customers”.
Step
3:
I
want to show Top 11 to 20 Customers. To Archive this we need
to create Combined Set based on “Top 10 Customer”
and “Top 20 Customers”. Right Click on “Top 10
Customers” Set and create combined set.
Here
I am excluding Top 10 Customers from Top 20 Customers.
So that I will get Top 11 to 20 Customers.
Step
4:
Now
Create a calculation field to divide the Customers into these 3
groups. Name the Calculation field as “Customer Group”
Step
5:
Drag
“Customer Group” into Rows and Sum(Sales)
into Columns.
Step
6: You will See Bar Chart by Default. Now go to Show Me
and select Pie Chart. Turn on the Labels by clicking “Abc”
icon.