0 Replies Latest reply: Oct 27, 2010 6:01 AM by EduardoGonzalez RSS

    Get cell value from a straight table

      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