my source data:
my requirement is
1)when i select 2015,then it should compare with previous year(2014) and display common Id column records in 2 years.(here 1,3 are common in 2015 and 2014)
2)when i select 2014,then it should compare with previous year(2013) and display common Id Column records in 2 years.(here 1 is common in 2014 and 2015)
It is showing right results. But the why the below formula showing incorrect, I think.
Please correct me if I am wrong. Thank you.
That's a bug in the syntax checker of the expression editor. It doesn't understand that *= means to calculate the intersection of the default set with the set calculated with the p() function