hi every body

[satheshreddy]

hi,

how to find out avg in chart.

i have table columns are

eid,ename,did,salary

i take a filter of eid

select the eid value then to display the that particular did sum(salary) and also avg of that particular did salary.

kind regards

esreddy

Message was edited by: s r

[Anonymous]

=Concat(distinct DID,',')

will give all possible values of DID with current Selections

and the expression below will give universal set avg Salary of possible values of DID with current Selections

avg({1<DID={$(vListDID)}>}SALARY)

the expression you are saying will give Avg of only values of emp selected and not the whole department

[vishsaggi]

HI SR,

Just another way of doing this is:

Using Straight Table Chart:

Dimensions : Add DID

Expressions: 1. Sum(SALARY)

                    2. Aggr(Avg(SALARY), DID)

Regards,
Vish.

[satheshreddy]

hi vishsaggi

Aggr(avg(SALARY),DID)

it shows only particular selection EID  avg

my requirement is particular selection EID department total avg 

[satheshreddy]

HI SAGAR

avg({<DID=>}SALARY)

it shows only particular selection EID  avg

my requirement is particular selection EID department total avg