How to Hide Values based on Pivot Table?

[#1]

I am finding diffcult to hide values which is more than $15000 on a Sum? any ideas would be appreciated.

I doing a total on a particular column and a subtotal,but at the same time based on the sub total,i would like to hide any values less than certain amount...eg:- $15000..

thanks for your help

[#2]

attaching a qvw...

[sivarajs]

check the attached file

[#4]

Thanks for your time...but i was expecting...like..

eg:- if you search by 18011 it does have two values ie...173k and 3895...i would like to keep those two rows but only if hte sum of those two is less than 15k then hide it...that is where my problem is...

thanks for your help.

[#5]

Hi,

I am confused whether u want to exclude value with more than 15000 or less than 15000.

Use the below expression for excluding value less than 15000

Instead of using SONUM dimension directly create a calculated dimension

IF(aggr(sum(BACKORDERQTY_1),SONUM) >=15000 , SONUM)

Regards

Ankur

[#6]

thanks it works...thanks for your help on this...

[#7]

now i seem to have different problem on the same issue..how do i place filter on the backorderqty_1

ie

if there are 3 records

sonum    backorderqty_1        ship?

1                 10000                      1

1                  5000                        0

1                  2000                        1

2                  16000                      1

3                   19000                      0

now the values i should reterive is

2              16000              1

but i am having

1            12000           

2             16000          

i am having great diffculty to fix it..

//IF(aggr(sum(BACKORDERQTY_1),SONUM) >= 15000, SONUM)

// IF(aggr(distinct sum(BACKORDERQTY_1),SONUM) >=15000, SONUM)

//IF(aggr(SHIP=0,sum(BACKORDERQTY_1),SONUM) >=15000, SONUM)

//IF(aggr(IF (SHIP=0,sum(BACKORDERQTY_1),SONUM)) >=15000, SONUM)

none of these work..

Thanks for your reply