2 Replies Latest reply on Nov 22, 2018 10:24 PM by siva sandeep

    How to make state and city dynamic pane wise

    siva sandeep

      Hi all,

       

      i want to compare sales, Top N State and Top M City wise dynamically using parameters. When I select Top N State it should show states with the cities. When I select Top N City it should show according to the state pane wise individually in a dynamic way. I tried using Rank(sum(sales)) <= Top N state AND Rank(sum(sales)) <= Top M City. But, I'm unable to get it. I attached the workbook below. Kindly please check and update me. Many thanks!

       

      Regards,

      Siva.