Display of Grouping of not required data to other in Pie Chart

[berryandcherry6]

Hi,

i have below data

mobileDeviceModel	sum(MobileUsers)
(not set)	213
0P6B130	23
0PAJ5	1
0PCV1	6
0PCV220	5
0PJA1	1
0PJA2	2
0PM92	5
0PM912	1
2PQ93	2
2PS64	1
2PST2	2

Here i need to show pie chart for Models whose value is greater than 1.and other which are <= 3 should be shown as other in piechart with legend. How could i do this?

[Anonymous]

I do not see anything     <= 1  ??

[berryandcherry6]

Hi allu,

Those are dynamic values. If in case if there are values like '-' , null those are all should be grouped to other.

[Anonymous · Accepted solution]

=if(

Aggr((Sum(MobileUsers)), mobileDeviceModel)<=3,

mobileDeviceModel,

'Others'

)