Hint: How to filter Dimensions Based on complex Calculations

[Anonymous]

To filter dimensions based on complex calculations I use the following way:

Use the Pareto Select as an action in a button. The trick is the expression.

Put your condition in the form

If( condition = true, 1,0) and select the percentage as 50.

The condition can be really complex. Don't use "=" at the beginning of the expression in front of if (bug ?).

Together with a select excluded button, this is very powerful and user friendly.

I hope this is interesting for you.

Norbert

[#2]

Could you post a small exempel? I don't really fellow (ok it is late over here...). But I'm curious!

Thanks in advance!

[Anonymous]

Roberto, please see attached example.

Regards

Norbert

[#4]

Nice! Thanks!