5 Replies Latest reply: Apr 1, 2017 1:22 PM by eeacrw cewdbr RSS

    Selections and pie chart: show among all and among selection

    eeacrw cewdbr

      Hi all!

       

      I want to show a client position in all benchmark data, and also - in his/her industry.

       

      What I have:

      When I select a client (CLnum) in filter - I see pie chart colored where he relates to.

      I use {1} in count() formula in order to leave all the data in pie chart.

       

      I need to implement a Industry filter.

      And If I also select an Industry - I need the data in pie chart show only the numbers of industry selected.

      Now when I select the industry - it changes nothing on pie chart because I use {1} in formula....

       

      How to do it?

       

      See the attached file...