6 Replies Latest reply on Jun 18, 2018 2:08 AM by An Na

    Create dynamic view of dual axis

    An Na

      Hi there,


      Is there anyone who could help me with the following problem?


      I created this worksheet.


      In the first one you can see the Total "New Orders/Revenue" in the second one per Segment.


      I could also create a dual axis in this view, so you can see it all in one graph:



      I would like now, that if the User selects "All" that i can only see the line for the Total "New Orders/Revenue" and if the User selects for example "a" that he can only see this line.


      I tried to combine the two calculations but it doesn't work. Any ideas how to solve this problem?


      Thank you very much.