How to do an Absolute Count

[#1]

Hi All,

I'm currently developing a dashboard that is requiring an total absolute count of headcount relative to what is selected.  Below is an example.

The two tables are joined by User_Id

If I select Jan_2012 I get the following results.

Org_table:		Ticket_table:
User_Id	Bus_Unit	User_Id	Month_Year	Ticket_Id
Usr1	BU1	Usr1	Jan_2012	Tkt1
Usr2	BU1	Usr2	Feb_2012	Tkt2
Usr3	BU2	Usr3	Feb_2012	Tkt3
Usr4	BU2	Usr4	Feb_2012	Tkt4
Usr5	BU2	Usr5	Feb_2012	Tkt5
Count (User_Id)		Count (Ticket_Id)
Result	1	1
Desired Result	5	1

If I select BU1 I would get a count of 2 and ticket count of 2.

I'm basically trying to do a count on the User_Id field within the Org_table regardless of the associative records of the Ticket_table

Thanks for any help or suggestions.

[#2]

Try Count({1} User_Id)

[#3]

When I select BU1 I get 5 when I'm looking to get 2.