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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AS2K/XL2K: Pivot-elem. & Filtering Measure-elements

Status
Not open for further replies.
twolf

twolf

Programmer
Nov 27, 2001
4
DE
Hi,

how can i filter the elements of an cube (SQL-Server2000) in Excel 2000 when i use the pivot-element? Sclicing & dicing isn´t the problem, more to filter dynamical the elements, e.g. measure.amount >= 1000 AND measure.amount < 10000 .
All ideas are welcome.

Thanks in advance.
Thorsten



 
Status
Not open for further replies.

Similar threads

dldev
  • Locked
  • Question
Date Formatting for OWC/Pivot Table RowAxis field
Replies
1
Views
39
dldev
dldev
19972003
  • Locked
  • Question
ODBC &amp; Access 97
Replies
0
Views
47
19972003
19972003
kfschaefer
  • Locked
  • Question
New to OLAP &amp; Pivot Tables(Excel)
Replies
1
Views
37
MDXer
MDXer
icowden
  • Locked
  • Question
Refresh one OLAP Cube toupdate multiple spreadsheets / pivottables
Replies
5
Views
69
MDXer
MDXer
glucaguerra
  • Locked
  • Question
Olap &amp; Excel
Replies
2
Views
37
cryrep
cryrep

Part and Inventory Search

Sponsor

Back
Top