Set-analisys in pivot table

[Anonymous]

Hallo!

In the attached example I'd like to show the rows of the pivot table only if the sum of the credits for a single customer is greather than its thresold: can someone help me to set the set_analisys formula?

Yhank you very much.

[swuehl]

Try something like

if(Sum(Credit)>Threshold,sum(Credit))

[Anonymous]

Well, you're right...the sample I gave is an extraction of my table which contains more fields in the expressions, so I think have to set the condition in the dimension field with the set_analysis. I apologize if I didn't post the correct example the first time.

Now I attached it.

Thank you.

[swuehl · Accepted solution]

You can try like attached, checking in all your expressions if the sum(Credits) is applicable, e.g. in first expression of your sample

=if(column(2), sum(Invoice))

[Anonymous]

Very good!! Thank you very much.