Count in Parameter wise

• narendra.babu57

  Old Hand

  Points: 386

  More actions

  November 29, 2013 at 2:12 am

  #148001

  Hi All,

  I need mdx query

  my hirachy is : country,state,city,district

  Dropdown list : Country,state,city,distirct

  Now if I am selecting country :Inida

  then I want count State count: 23

  citycount: 500

  distictcount: 1500

  if suppose I am selecting state: Andhrapradesh

  then I want count city count: 50

  district count : 25

  like I want any one suggest me how will I do it..