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?
Anyone... hello... Bueller?