Pie Chart: Dimensional Limits: Pareto Selections

[#1]

Hi All,

The problem i am facing is that i have a source table in this format:

Plan_Name| Favourable | Volume|

A| Y | 10

B| Y | 15

C| N | 5

D| N | 6

E| Y | 12

....... 500 Records

I need to plot a pie chart with 6 sections to it.

First 5 Sections has Plan Names with Favourable Flag as Y. The 6th Section is others of the total plans (Not only other of favourables).

Top 5 Favourable Plans and Others of the total plans (including non favourable)

Dimension limits only gives me others of the favourable plans.

Any help would be highly appreciated.