The query below shows how many uses purchased an item from each of two clothing departments.
Why are the total and sum of the rows unequal?

Question

The query below shows how many uses purchased an item from each of two clothing departments.Why are the total and sum of the rows unequal?

Haitham Hanash · Accepted Answer

A user is only counted once in the total even if the user has purchased from both departments.

Haitham Hanash · Answer

There is a filter limiting the count in the Total row.

Haitham Hanash · Answer

There is a faulty logic in the way users relate to clothing departments.

Haitham Hanash · Answer

There are users who have never purchased a clothing item from either department.

List of questions