Anyone who can tell me how to get the conditional section to work.
I have a pie-chart showing departments results, but if one department is having a negative result it's not shown in the pie-chart. But then I'd like a text box to appear letting know about it, and showing the departments name and results.
I've tried with a
sum(Profit)<0
but it sum all departments, it doesnt seem to take the dimension into consideration.
Anyone who know how I can check if one or more departments is having a negative result for the selected period?
