Problem with Pie chart and Hierarchy

I have to display a Pie chart according to a hierarchy.

The top node claims half of the chart.

<u>A hierarchy for example</u>:

Division A 450

Department A1 100

Department A2 150

Department A3 200

The Pie chart is divided to 4 parts (instead of 3), where Division A takes 50%.

I don’t want Division A to be seen in the chart.

The best solution would be if WAD could ignore the first category.

Thanks and best regards,

Sigal.