Hi There,
I have created this query and i want to return the top 5 suppliers per LOB. It is returning something but it is not the top 5. I want to limit only to return the top 5. Pls. help and thanks. See attached file.
In (select top 5 [Detail].[SumOfAnnualNonContractSpend] from [Detail] where [LOB].[Line of Business] = [Detail].[Line of Business] Order by [SumOfAnnualNonContractSpend]Desc)
set this statement in SumOfAnnualNonContractSpend criteria
The query is not working after i put this in the criteria:
In (select top 5 [Detail].[SumOfAnnualNonContractSpend] from [Detail] where [LOB].[Line of Business] = [Detail].[Line of Business] Order by [SumOfAnnualNonContractSpend]Desc)
did you test it and see if it is working? I am getting error which says "data mismatch"