group

[soniasweety]

hi ,

I have field like  region,   in that I have   south ,north,east,west     In each region I have some other states

so  I have a pie with the  region   and count(id)   so    I need  to show   only     South and North   count only how to do that?

region is coming from 3tables  used applymap to get the region.

how to group only  north and south?

[its_anandrjs]

Share sample or do like this

count( {<Region = {'north','south'} >} id)

Note :- In dimension select Suppress when value is null

[Anil_Babu_Samineni]

Can this do?

count({<region = {"South","North"}>} id)

[avinashelite]

Other way would be

in the dimension

if(Region='north' or Region='south',Region)

suppress null in the dimension

expression

Count(id)