count of industry

[Rajareddy]

in my table like

code,   id,   group,  industry

0001 ,   ab ,  a   ,    bpo

002,    ac ,    c,         it

0020 , tc , a , bpo 

i want show for  how many bpo  industry show in ui and script level

thanks

raja

[MayilVahanan]

HI

Try like below

Count({<industry  = {'bpo'}>}distinct code)  

or, you can count the id or group , it depends on ur requirement.

[Rajareddy]

i want show  how many  bpos  and how many it  industry count like

bpo 2 

it 1 

etc 2 

[MayilVahanan]

Hi

Add Industry as Dim, 

Measure: Count(Distinct code)

[Rajareddy]

it's possible to back end

[MayilVahanan]

Hi

Try like below

Load Dim, Count(Distinct code) as NoOfCode resident tablename group by Dim;