TOPCOUNT
SELECT TOPCOUNT([DimCreationTime].[Year].[Year], 2,
[Measures].[NQ Download Count]) ON COLUMNS
, NON Empty [NQ Download].[Source].[Source] On ROWS
FROM [LRRDownloadsCube]
--------------------------------------
Cube Calculations {new Name Set}
// No select or dimensions
TOPCOUNT([Customer - Territory].[Name].[Name], 10,
[Measures].[Sub Total])
No comments:
Post a Comment