Newbie OLAP pivottable filter and sort on values

J

Jerome

Hi,

I have the simpliest of cube pivottables: Year as report filter, Products as
Row labels and Amount as value.

Is there a way to filter (a cube pivottable) rows on values ie "amount >
1000" or "amount <> 0" ? I only find (when rightclicking Products row label)
"Filter top 10".

/Jerome

I use Excel2007 and AnalysisServices2005 sp3 cubes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotTable filter ordering 0
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Access PivotTable Date Filter VBA 0
How to sort a PivotTable based on OLAP Cube by one of the data fi. 0
Filter rows containing cells with values within a range (for example <11 or >10 but <21) 1
Pivot Table Code - Is there a better way? 2
Can I filter a table on a time criteria? 1
OWC: inaccurate reports from OLAP cubes 3

Top