Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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'.
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'.
Hi Linoy,
Can you please elaborate your problem.
Great!!! Thank you
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?
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...