Show second,third, and fourth

[Former Member]

Hi,

In my Table

-Name-

John

Cat

Dog

Dad

Mom

In my WEBI, I am able to pick up

=First([Name])

and

=Last([Name])

John and Mom

How do I able to show Cat, Dog and DAD ?

Thanks.

[Former Member]

HI Ragoth.C

I used the formula as u mention above, however, I am getting #MultiVALUE

Edited by: liliass on Feb 6, 2012 9:58 AM

[Former Member]

Hi,

Could you please elaborate the problem clearly.

Eg., How many dimensions you are using and what way you are expecting the output.

Either you created variable or not, if so how you are using that variable.

Regards,

Ragoth.C

[Former Member]

Sorry that I did not clarify everything clearly.

In my SQL Table,

there are number of value like,

John

Sam

Michelle

Vivian

Michael

So in the WEBI Table, I just want to pick up the Second Value in the SQL Table only.

please refer to the screenshot for better understanding.

http://i39.tinypic.com/b7xt8h.png

[Former Member]

Hi,

Try the below formula may be it will help you,

=[Device Name] Where (RowIndex()=1) - First name

=[Device Name] Where (RowIndex()=2) - Second name

=[Device Name] Where (RowIndex()=Max(RowIndex())) -Last Name

the above formula will give you the output based on the row index generated in table.

Regards,

Ragoth.C

[Former Member]

Hi liliass,

Before checking the exact formula for pulling those values, first sort the column because, later there might be insertion of records to the table and which may affect the formula. Can you please sort the field and tell the exact position that you wanted to display in report.

Thanks

rdineshkumar

[Former Member]

HI liliass

If you do not apply any sort based on the other fields then you can use the Rowindex formula.

= [Device Name] where( Rowindex() = 2)

This will return the second row data. But if u apply section or break again the order will change.

So, the output will be exact only when the report is a simple tabular report.

Regards

Shyam

[Former Member]

Thanks..

[former_member184624]

Hi,

I have a query. THe below values are coming from the same field ? How will you differentiate first name and last name ?

THanks & Regards,

Jelina

[Former Member]

Hi,

Try this formula I hope this will help you to get the expected output,

[Name] Where ([Name] != Last([Name])and [Name] != First([Name]))

Regards,

Ragoth.C

[Former Member]

What if I only want the second value ?

[Former Member]

Hi,

The below formula to get second value,

=[Name] Where(RunningCount([Name])=2)

If you want to get only specific values corresponding to the row position.

Then you need to create a object in universe to get 1,2,3,4,5,6,etc.

Then put report filter and choose whatever choice you want by passing that value in the above formula.

Regards,

Ragoth.C

Edited by: Ragoth.C on Feb 4, 2012 11:11 AM

Edited by: Ragoth.C on Feb 4, 2012 11:11 AM