Sum rows for pie chart with two values

[atowne]

Hi there,

I have a dimension with 10 values, but I want to sum 9 of them into a single value to display on a pie chart with the other 1 value. So one value represented on the pie chart would be sum(1-9) and the other would be the 10th. 

Does anyone know how I'd be able to accomplish that?

Example:

Dimension	Measure
1	7
2	3
3	8
4	24
5	51
6	81
7	15
8	29
9	33
10	62

The sum of rows 1-9 is 251, so I'd want that to be represented by one value that's 80.2% of the pie chart with the other 19.8% being the 10th row, or 62.