Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Top 20 order and rest grouped into 'others'

Status
Not open for further replies.
tomgao

tomgao

Programmer
Feb 25, 2003
30
0
0
NG
Hi guys.

I want to create a top 20 product list from a few thousand products. I want the rest of the products to be grouped into 'others'...

I also want the products to be ordered by the facts in the cube. Thus the product dimension would dynamically change depending on the Time dimension thats being selected.

is this plausible ?

Thanks
Tom
 
Status
Not open for further replies.

Similar threads

Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
117
Vary88
Vary88
tarikqazza
  • Locked
  • Question
problem with calculated member and currentmember
Replies
0
Views
47
tarikqazza
tarikqazza
acent
  • Locked
  • Question
converting an integer field into a date
Replies
1
Views
36
SkipVought
S
briangriffin
  • Locked
  • Question
VFP and Windows 7
Replies
0
Views
24
briangriffin
briangriffin
shanzek
  • Locked
  • Question
Importing ODBC Driver into Registry with Password
Replies
0
Views
20
shanzek
shanzek

Part and Inventory Search

Sponsor

Back
Top