2 Replies Latest reply: Aug 31, 2012 3:17 AM by jagan mohan rao appala RSS

    Set analysis problem in straight table

    MCPL MCPL

      Hi,

       

      I have created a straight table to display a data set by year.  The table uses set analysis to compare with last year.

      However, the set analysis creates a new row (previous year) in the table (see attached).

      In the attached '2012' is a selected value.  You will note that the row '2011' has been created and the set analysis for previous year (Prev Yr) is inserted on this row.

       

      How can I remove to automatic creation of the previous year's row (2011) and move the 'Prev Yr' set analysis calculation (value showing 94) to the row above it ('2012').

       

      Cheers

       

      Karl