7 Replies Latest reply: Mar 11, 2016 5:35 AM by vikas mahajan RSS

    Customize chart after calculus condition not satisfied

    Ant�nio Vilares

      I have a chart pivot table which the same function as as listbox ( in first picture ).

      Chart.PNG

      When the calculation condition is not satisfied I do not want show values in listbox. At this time, it returns the following graph:

      Error.PNG

       

      Is there any way to customize the type of chart that appears (at least the colors ) if the error message is not satisfied ? It's a little bad present this white box to my customer If the conditions isn't satisfeid

       

      I've tried with the following expression in Tab Dimension but is not effective as it reveals some problems:

      =IF(GetSelectedCount(Team) <=1,ID)

      Basically, I only want to show ID if only have 0 ou 1 team selected.


      Thanks!