How to pick one member from a list?

[#1]

Hi All,

I have a list which contains A1, A2, A3 and i have to display them individually in different charts. how do i do that?

[#2]

if (Field_name='A1')

you can use if formula

for ex: sum (if (Field_name='A1'), Field_name)

if you explain as detailed we can help you

best regards

[#3]

Hi,

if you are using this list as dimension just put a calculated dimension like this->

=if( List = 'A1' ,List)

and suppress the null values then you will get data in that chart only for A1.

[#4]

Hey guys,

Thanks for replying..

But both of the above doesn't solve my problem..

My problem is that i cannot refer to the list by the field name for an example 'A1' here..

I want to get it by position or something like that..because there are about six lists containing different field names and i am using the same object for all of them..

e.g.

RM1 has AM7, AM9, AM12,.... so on

RM2 has AM14, AM22, AM45..so on

.

.

.

RM6 has AM67, AM56... so on