2 Replies Latest reply on Jun 10, 2018 11:14 AM by Arnab Chaudhury

    Drilldown on click over chart objects

    Arnab Chaudhury

      Hi Experts,

       

      I need to drill down by clicking on chart objects. For example if I click on bar of California for category furniture it should drill down on the same worksheet showing the result of all cities of california for category furniture.

       

       

      to

       

       

       

       

       

      This I have achieved through action filter. However this jumps between worksheets. Can it done through sheet swapping? Sheet swapping mechanism seems so cumbersome. There should me more convenient way of achieving this, like when done in PowerBi and SSAS.

       

      Thanks in advance.