Conditionally suppress pivot table rows

[#1]

Hi,

I have a pivot table like so:

Dim1 values = category1, category2, category3

Dim2 values = LA, NY, SF

There are two expressions = exp1 and exp2

Dim1       category1         category2          category3     

Dim2      exp1   exp2       exp1   exp2        exp1   exp2

LA           5         6           12       9            10      1

NY          12       11           7        8            2        1

SF           5        1             2       11           7        3

What I need to do is to hide those rows whose exp2 value is less than 2 for the last element of Dim1 (category3 in this example). So here, I would want to hide rows for LA and NY, but not for SF. Please note that SF has its exp2 less than 2 for category1, so it should display.

[#2]

Please attach example

[#3]

Here is a sample qvw. here again, SF should display and the other two rows hidden since their cat3 value for the Score expression is less than 2.

[#4]

not possible. Use Straight table and try