Cannot count total distinct individuals when filtering by year and/or quarter

[#1]

I'm pulling data from two datasheets and want to count unique individuals by doing a temporarily resident load. How would I enable the Count(Distinct([people])) to count unique individuals for the entire year, but then also have a quarter filter be able to count(distinct [people])? Thanks in advance!

[swuehl]

I think Jagan asked you to provide some sample data and the requested results.

I agree this would probably help us to understand and help you.