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

    Different Charts While drill

    Govind Ramchetty


      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.