Filter rows in a table based on expression result

[linoyel]

Hi!

I have to show agents and their sales where sum of sales is a set analysis expression: Sum( {$<$(s.Month.Current), upgrade_group = {0}>} income)

- but only if sum of sales is less then 6000.

How do I do it?

[tresesco · Accepted solution]

Try like:

=If( Sum( {$<$(s.Month.Current), upgrade_group = {0}>} income)<6000,

           Sum( {$<$(s.Month.Current), upgrade_group = {0}>} income),

     0)

Then in the presentation tab check 'Suppress Zero Values'.

[avinashelite]

Hi Linoy,

Can you please elaborate your problem.

[linoyel]

Great!!! Thank you

[linoyel]

I have it a bit more complicated now...

I need to show agent sales in the same table for current and previous months, only when in current month sum of income < 6000.

The problem is that when in current month some agent sold for 7500 then I get 0 which is not getting suppressed cause I have other values of previous month which are not 0...

So how I can hide these lines which get "0"  in the sales of current month?

[linoyel]

Well, I managed to do it, but I loose values which are 0 cause there were no sales. They are suppressed together with not matching values...