filters pivot table

[#1]

Hello,

I have a pivot table with the following fields :

Dim1

Dim2

Dim3

sum(val1)

sum(val2)

sum(val3)

I need to know how can I filters records with the following condition :

sum(val1) > 1000 and sum(val2) < 2000

Thank you

[PrashantSangle]

Hi,

Create your expression in Script level and there you can manipulate it.

Regards

[tresesco]

One way could be like:

Rewrite the expressions like:

Exp1: If( sum(val1) > 1000 and sum(val2) < 2000 , 0 ,  sum(val1))

Exp2: If( sum(val1) > 1000 and sum(val2) < 2000 , 0 ,  sum(val2))

Exp3: If( sum(val1) > 1000 and sum(val2) < 2000 , 0 ,  sum(val3))

And enable the 'Supress Zero Values' in the presentation chart.

[jagan]

Hi,

Try like this

If(sum(val1) > 1000 AND sum(val2) < 2000, "You expression here")

Regards,

Jagan.

[#5]

Please find solution in attachment and let me know .