Infact I do not even car about a filter but more so just do not want to see the duplicates in my data.
Did you tried countd aggregate instead of sum on F2.
You are right Zach. I was thinking distinct count.
if the numbers are same Zach gave u the answer. If they are going to be different, then you change F2 in dimension and you will have what you need.
Yes the numbers are the same just trying to get rid of duplicates.
Thanks for your help here The specified item was not found. and Zach
Zach thanks that worked.