set anylsis question

[#1]

Hi all.

have a table having employee_no and bill

employeeno	bill
6123	200
4252	450
SUP-GK-452	250
4535	400
SUP-GK-333	350

actualy SUP-GK-452 and SUP-GK-333 are code for retired employees.

I want to show the sum in graph only those employee who are not like 'SUP%' in one graph and

only for those who are like 'SUP%; in another graph.

how can i do this through setanylsis.??

[CELAMBARASAN · Accepted solution]

Hi,

     Try with this expression

     Sum({<employee_no-={'SUP*'}>} bill) for not 'Sup%'

     Sum({<employee_no={'SUP*'}>} bill) for 'SUP%'

Hope it helps

Celambarasan

[v_iyyappan]

Hi,

     Use the expression like,

not like 'SUP%'  = if(left(employeeno,3) <> 'SUP',Sum(bill))

like 'SUP%'  = if(left(employeeno,3) = 'SUP',Sum(bill))

Regards,

Iyyappan

[jagan]

Hi,

Try this

not 'Sup%' =Sum({<employee_no-={'SUP*'}>} bill)

'SUP%'=Sum({<employee_no={'SUP*'}>} bill)

Hope it helps you.

Regards,

Jagan.

[#5]

hi...

you can use

"=Sum({1<Emp_NO={"SUP*"}> }Bill)"   for SUP*

and

=Sum({1-$<Emp_NO ={"SUP*"}> }Bill)

for other

Thanks and regards

Arun Goel

[#6]

thnks sir..

its really works