How to group values in a pie chart? Very urgent! Please somebody say something!

Hi all,

Assume I have a pie chart whose Value: isInternet Sales Amountand Category group: isProduct Subcategroy. Suppose I have 5 segments(slices) with the value 200,150,80,50,and 40. Now, here is the question; I want to aggregate those values that are less than 100 (in this case the last three values: 80+50+40 = 170) and put the sum(170) in one segment, so that in the new pie chart we will have only 3 segments with the value 200,250, and 170.

Any idea is appreciated.

[613 byte] By [Amde] at [2007-12-23]