OLAP - Uniqueness for the quarter

Hi All,

We are encountering problems with quater count of records.

Uniqueness is accurate for month; not if you aggregate for quarter or year; for example, user is active in Jan, Feb and Mar The system would accurately show 1 active user for each of these months, but would show 3 active users for the 1st quarter (doesnt recognize that its the same unique user).

We want to count the active user only once for that quarter.

Is the way to count that active users only once for that quarter instead three times. Please help and your input is appreciated.

Thanks and have a nice day.Use this format for your count:

Select Count(Distinct UserID)
From YourTable
Where.........

blindman