Count() not giving right results

[Former Member]

Hi ,

I am on 4.1 latest patch. I have a webi reports which primary has below columns

Product_Make      Product_Model      Count_of_customer      payment_mode(cash/card)

Product_Make: is a dimension and has values coming ffrom Prod_cust table

product_Model : Is a dimension and has values coming from prod_cust table

Count_of_customer: report level variable which is basicall count(customer_id) where customer_id coming form prod_cust_table

payment_model : Dimension and has value coming from prod-cust table

So, the problem is

the count_of_customer column is not showing up correct counts.

When I add a filter in Query panel for a specific make and model , That's when the count_of_customer column bring back the right counts.

Please advice.

[Former Member]

Try count([Customer ID]) In([Product_Model];[Product_Make])

If that doesn't work give some more details as to what the count variable is displaying and what the expected display is.