I have a dimension say Issues with 100 members.
I wanted to have a calculated member which gives me the Top 10 Issues.
I want to use this calculated member in Excel Pivot table ( by drag-drop).

I am able to get the desired result by using the following MDX query
Select
{Count} ON COLUMNS,
{TopCount({[Issues].Members}, 10, [Count])} ON ROWS
From Customer


But how do i make this as a calculated member.

Thanks
-BizWiz

A calculated member can be a calculation based on the top10 (i.e. sum or
average), but a member can't contain multiple members. Maybe a named set is
what you want? Named sets are defined in the cube editor, like calc
members -- you've already got the expression.

tom @ the domain below
www.tomchester.net


"BizWiz" <sundaresa (AT) hotmail (DOT) com> wrote

p.s. Unfortunately named sets are NOT available in pivottable.

tom @ the domain below
www.tomchester.net


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote