Generate Pie chart after grouping data

Uday Reddy

Below is the sample data (attached as File1.csv)

---

Person

---

Week

---

Count----Model_Type

---

BASKIN CINDY HOPE MD----04-JUL-11

---

1

---

Type2
BASKIN CINDY HOPE MD----04-JUL-11

---

1

---

Type1
...
...

1. Need to group on Model_Type
2. Need to group on the Person and find out the Total_Count
3. Generate pie chart for each Modality, Person Vs Total_Count (only top 10 Total_counts should be shown on the chart)

mwilliams

Take a look at this example. I believe it does what you're wanting. I use groupins, aggregations, and a filter to achieve this. Let me know if you have questions or if something isn't right.