Please Help Me

[rajveersinghsisodiya]

hi i need to create some table or chart like specified below:- 

Field NAme	Avg	Stdev
Name_of_field_1	10.2	2.5
Name_of_field_2	15.76	4.6
Name_of_field_3	16.56	5.6

all this feilds are from one table. 

[alexandros17]

So use field name as dimension and two expressions:

avg(myValue)

stDev(myValue)

[rajveersinghsisodiya]

thanku so much Gysbert Wassenaar

it working.

[rajveersinghsisodiya]

hi Gysbert Wassenaar one more problem in this table, only one field should be seen  when it get selected from list box.

[Gysbert_Wassenaar]

If you have a listbox with field names then you either have or can create a field with the field names. You can use that field, e.g. FieldNames, as dimension and change the expression to

pick(match(FieldNames, $(=Concat(chr(39) & '[' & FieldNames & ']' &  chr(39) ,','))),

$(=concat( 'avg('[' & FieldNames & '])', ','))

)

[rajveersinghsisodiya]

hi Gysbert Wassenaar its not working.

i will explain the scenario. i have one list box in that values are

• Name_of_field1
• Name_of_field2
• Name_of_field3

and i have one table in that i need to show Avg and Stdev of one  selected value from above list box.