Top Values by group 1

[kastaman]

Hi there,

I'm creating a report where the top issues by business segment is reported. I followed the instructions in the Microsoft site:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q132056

but when I run my report, the Line of Business is appearing about 10 times with the same top 5 issues.

My tables are straighforward:
Line of business
Data

These 2 tables are joined by the product field.


Thanks in advance,

Kastaman

 

[padinka]

I'll take a stab at the query for you. Try this

SELECT TOP 5 [Line of Business].[Line of Business Field], Count(Data.[Issues Field]) AS [Issues]
FROM Data INNER JOIN [Line of Business] ON Data.Product = [Line of Business].Product
GROUP BY [Line of Business].[Line of Business Field];
Trisha
padinka@yahoo.com