2 Replies Latest reply on Jul 26, 2016 4:25 AM by Govind Ramchetty

    Different Charts While drill

    Govind Ramchetty

      Hi

      I have pie chart report like

       

      Prompt (values-->A,B,C)

       

      Pie chart

       

      When I select prompt=A means my pie chart will display corresponding values.Same way when I select prompt=B and Prompt=C.

      It working fine. This done in single worksheet.

       

      Now when I click my pie chart, it should display another sheet Line chart based on values.

       

      Now my requirement is

       

      Prompt A-->Drill in pie-->Sheet2 Line chart

      Prompt B-->Drill in pie chart--> then it should display Bar char

      Prompt C-->Drill in pie chart-->It should display Scatter chart

       

      Each drill it should display different charts. How can I achieve this. Can you pls help.