Set analysis problem in straight table

[Anonymous]

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

[Jason_Michaelides]

What is the set analysis expression you are using? I suspect it is cancelling the Year selection.

[jagan]

Hi,

Check attached file, hope it helps you.

Regards,

Jagan.