Get cell value from a straight table

[#1]

Hi everyone,

I dont know if there is any way to do this.

I have a Straight Table like this:

Example1:

HOTEL NIGHTS TOTAL_SPENT

NewYorker 4 400$

Fashion26 3 280$

Hotel123 2 180$

......

Example2:

HOTEL NIGHTS TOTAL_SPENT

Hotel123 2 180$

NewYorker 4 400$

Fashion26 3 280$

......

This table is an Straight Table and have 1 Dimension ('HOTEL'), and you can order the information by NIGHT or TOTAL_SPENT.

What I want to get is the 3º value of this table, placed in TOTAL_SPENT. I´d like to get allways the 3º value, doesn´t matter how you order the information.

In my Example1 the value I´d get will be '180$' and in the Example2 I´d get will be '280$'

Thanks a lot