5 Replies Latest reply: Mar 8, 2012 1:01 PM by Stefan Wühl RSS

    Defining a table within a data table

    James Newcombe

      Hello

       

      Can anyone help me with this? See the attached spreadsheet for details.

       

      I've got a very specific table to build in QV. Each value in the table is calculated differently so a standard table isn't going to work very well (at least I don't think it will), see the green table to see that sort of thing I want. The blue cells show the data behind the table.

      What I'd like to do is define the items in the table inside an inline table, see the yellow table.

       

      The rowtext column of the yellow inline table would be used as the dimension in the green table. For each row, the related function in the inline yellow table would be used as the expression to calculate the value in the green table.

       

      Does this make sense? Am I off my trolley? Is there a better way of doing this?

       

      Any help would be appreciated!

       

      Thanks.