/content/folder[@name='Cognos SAMPLES']/package[@name='GO Sales (analysis)']/model[@name='model']
[Sales (analysis)].[Time].[Time].[Quarter][Sales (analysis)].[Sales].[Revenue][Sales (analysis)].[Products].[Products].[Product line][Sales (analysis)].[Retailers].[Retailers].[Region][Sales (analysis)].[Sales staff].[Sales staff].[Sales region][Sales (analysis)].[Order method].[Order method].[Order method type][Sales (analysis)].[Products].[Products].[Products] union(
_firstFromSet (
[Dim]
, 4
, 1
)
, _remainderSet (
member(
currentMeasure - total(currentMeasure within set _firstFromSet([Dim],4,1))
, 'Other'
, 'Other'
, hierarchy([Dim])
)
, [Dim]
, 5
)
)total(currentMeasure within set [Top 5])order(#sb(prompt('Dim','token'))#,[Revenue],BDESC)total(currentMeasure within set [Dim])
All
Top 5All
No Data Available
number2string(RowNumber()) +'. '
No Data Available
number2string(RowNumber()) +'. '