Count ignoring multiple dimensions

[#1]

I have a simple table and wish to count how often a customer is found in the table.

Date     Reference     Customer

I want to count the frequency of the field Customer

It sounds so simple but I cannot get my head around it.

Thanks for help

[sunny_talwar]

I am not sure I understand the question. Count(Customer) as an expression with Customer as dimension isn't working?

[datagrrl]

Is reference the field with the expression? It should work.

Maybe an example QVW would help.

[engishfaque]

Dear PM,

Please check listed below expression,

=Count (Aggr (Count (Customer), Date, Reference))

Kind regards,

Ishfaque Ahmed

[#5]

I've attached an extract qvw of the data I am trying to analyse.

Thanks for your help !

[sunny_talwar]

May be this?

=Count(TOTAL <[cust-code]>[cust-code])

The above is saying that cust-code K982 is repeating 19 times in this table for your current selections. Is this close to what you wanted?