Report Portal

Instead of HEAD + ORDER, why don't you u

Instead of HEAD + ORDER, why don't you use the TOPCOUNT function directly ? SELECT {[Measures].[Reseller Order Quantity]} ON 0, TopCount([Date].[Calendar].[Calendar Year].Members,3, [Measures].[Reseller Order Quantity]) ON 1 FROM [Adventure Works];

 

2007-2015 VidasSoft Systems Inc.