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.

       

      Best,

      Anna