Set Analysis is not working properly

[Anonymous]

Hi,

I have created 2 straight tables to compare the data of selected year and its previous year.

In first table I am showing the  previous year data using the below condition in set analysis for year->

Year = {$(=GetFieldSelections(Year)-1)}

And in 2nd table I am using ->  Year = {$(=GetFieldSelections(Year))} in set analysis.

When I am selecting any year, in 1st table it shows proper data of selected year but in 2nd table it shows only its total at the top. I have sorted the column in descending order but still it is not showing any data in the table except total.

I am attaching the screen shot.

can anyone please help me on this?

- Poonam

[sunny_talwar]

Because you were still wanting to see the selected year's information in the above table. Problem is related to selection here. When you are selecting a particular year, you cannot see last year without using set analysis.

[Anonymous]

Hi Sunny,

Got it now Thanks for the explanation.

- Poonam