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').
