Hi PG, Thanks for the reply and am having one more question!!! trust me this is the last one:smileylaugh: Am having dataset where members went to different movies i.e there are 100 members seen movie Frozen in 2013 and 100 in 2014, 100 members seen movie Avengers in 2013 and 100 in 2014 , 100 members seen movie Titanicin 2013 and 100 in 2014. Members can repeat across movies and across 2013, 2014 that means a member can go to all three movies in 2013 and in 2014 or he can go to only one movie in 2013 and two in 2014 and a member can have multiple rows for each movie. So now I need to flag 10% of distinct members for each movie, for each year but if member is selected in movie frozen 2013 he should not be selected again. Thanks!!!
... View more