Need to sum of items based on values to show in aggregated Pie chart

[ajitsingh]

Hi All,

I need to implement in Appsheet aggregated Pie chart view. For example we have following values in one of column as 2, 15, 3, 2, 1, 8, 8, 12, 17, 3, 2, 7, 18, 20, 30.

Now I need to show so these values in Pie chart view with just 2 category..

1 - all values count which are less than 10 (9 counts)

2 - all values count which are greater than or equal to 10  (6 counts)

Please help me

Thanks in Advance

Ajit Singh