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.
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.
Thanks for the explanation.
