Counts in a summary list?

[kgl_m]

Hi, I seek your help because I need to have counts in my list but its not working the way I'm doing it.

I have a list in which I have Product Name, Product Sales Count, Sales to X, and Sales to Y. I don't have counts for Product Sales, Sales to X or Sales to Y - I need to get the counts by evaluating a condition.

I need to have the list in the following fashion:

Product Name | Product Sales Count | Sales to X | Sales to Y
Telephones   |          100        |      45    |     55
Markers      |           50        |      25    |     20 (5 sales to some other entity which we don't care about)
I hope this explains the requirement.

Now, I tried the following: if ([Sale Type] = 2) then (count(Sale ID] for [Product Name])) else (NULL)

But it doesn't work.

How would you go about solving this?

[kgl_m]

Anyone... hello... Bueller?