Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
Try like below
Count({<industry = {'bpo'}>}distinct code)
or, you can count the id or group , it depends on ur requirement.
i want show how many bpos and how many it industry count like
bpo 2
it 1
etc 2
Hi
Add Industry as Dim,
Measure: Count(Distinct code)
it's possible to back end
Hi
Try like below
Load Dim, Count(Distinct code) as NoOfCode resident tablename group by Dim;