Wish to retrieve the top 10 SKU's, for a selected
department, but only wish to show the SKU and sales units

Department levels are:-
Department
Category
Section
SKU

The top 10 would be based upon the measure SLS Units

Output would be in the following format

SKU SLS Units
123456 20
987654 15
564789 10

Note that Department, Category and Section are not shown in the output

Hi,

with
set Top10SKU as
' Topcount( {Department.SKU.members}, 10, Measures.[SLS Units])'

select
{Top10SKU} on rows,
{MEasures.[SLS Units]} on columns
from MyCube

HTH,
Matthias

"Gary B" <gburke4 (AT) bigpond (DOT) net.au> schrieb im Newsbeitrag
news:a8e69edc.0409302142.37021fea (AT) posting (DOT) google.com...