Hi ,
I have attached a excel sheet with data that contains two fields
DATE
EMPID
In this data,i need output like
For 2016,it should display all EMPID.
For 2017,display the EMPID not in both 2016 and 2017.
For 2018,display the EMPID not in both 2017 and 2018.
using set analysis chart function.
My output should be:
If i click the year 2016-it will display all EMPID.
If i click the year 2017-it should display EMPID
i.e the year which is not in 2017 but in 2016
If i click the year 2018-it should display EMPID
GIS016
GIS017
i.e the year which is not common in 2017 and 2018.
Anyone help me to give solution.