Straigth Table Calculated Dimension Condition on some Other Dimension

[#1]

I have one calculated dimension which is a complex

IF(match( pick(1+match(...,...,...,...

Let's called this calculated field: Field1

I would like to have  a second calculated dimension which is further filtering the Field1 : if the sum of Revenues for one value of Field1 is more than 10k, keep the value, else drop it.

How could I achieve so?

Many thanks in advance

[#2]

Create this field in the script and after that will be easy filter the revenues grater than 10k in charts

[#3]

I cannot use the script but only the calculated dimension in a pivot or straight table. many thanks

[#4]

If you use that kind of calculated dimension and create a new one base on other calculated dimension will affect a lot the performance of your document.