Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

In a Cross Tab : I need COUNT and not DISTINCT COUNT. How???

Status
Not open for further replies.

DocLore

MIS
Apr 4, 2003
4
DE
Hi all,

I use a cross tab to count A's (row) per B's (column):

B1 B2 B3 Total

A1 1 2 4 7

A2 2 3 2 7

Total 3 5 6 14

B1, B2, B3 are groups with lots of b's in each group.

In each b, I can have a lot of instances of A1, A2.

However, the cross tab counts "distinct", although I
use a "count" in the "Format Cross-Tab..." menu.

What's wrong?
DocLore
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top