10 Replies Latest reply: May 7, 2014 10:19 AM by espen skeie RSS

    Use "Show/Hide" function in textbox

    espen skeie

      Hi

       

      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?

       

      Kind regards

      Espen