Pivot chart count

[#1]

I've seen a similar question to this on the forum, but it didn't solve my query.

I have a pivot table.

On the left, two dimensions: weekname then by sales person.

Along the top, one dimension: communication type (e.g. email, meeting, etc).

I simply want to count the number of communications per sales person, per weekname and by communication type.

Count(commno) (where commno is the communication primary key) doesn't work. It returns the same value for every record per column.

aggr (count(distinct CommNo),WeekName,EmployeeName,Comm_Type) doesn't work either.

Help!!! I'm quite new to this.

Thanks

James

[#2 · Accepted solution]

aggr (count( CommNo),WeekName)

aggr (count( CommNo),EmployeeName)

aggr (count( CommNo),Comm_Type)

I think this should work. If not, I dont have an idea.

[#3]

Thanks for your reply. And apologies. There was a problem with my data upload (the above formulae do work).

I had mistyped one of the field names (Id rather than ID) and so rather than link, the two qvd files had performed a Cartesian product, hence why my data was wrong.

Thanks again

James