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.
 
Top