title: Custom drilldown
body: <p>Good evening.
  Please tell me how to write a custom drilldown.
  There are city (City), every city has the number of births (Amount) for each day (for example: in the last month), the values ​​of today there is empty</p>
  
  <p>Here is an example of MDX query to the summary table:</p>
  
  <pre><code>SELECT NON EMPTY {[MEASURES]. [NEW_MEMBERMEASURE1], NONEMPTYCROSSJOIN ([Week]. [H1]. [Week]. &amp; [NOW], [Measures]. [Amount])} ON 0, NON EMPTY [DayName]. [ H1]. [DayName] .Members ON 1 FROM [HISTORYBORN]
  </code></pre>
  
  <p>The names of the rows are the days of the week (Monday, Tuesday ... Sunday)
  The first column with values ​​- the average number of births in all cities on a certain day of the week
  The second column with values ​​- the total number of births in all cities in the days of the week (ie. If today is Wednesday, the value of all days except Monday and Tuesday will be empty)</p>
  
  <p>Question:
  What I have to write in the "Drilldown Expression" in the "Axis Options" to a double click, for example on Tuesday,and it will display a list of cities and the number of births at Tuesday !<strong>of this week</strong>! without columns with average values ​​(first column) and of the city, in which this day has 0 born children.</p>
  
  <p>The names of the city in the next level
  [City]. [H1]. [Name]</p>
  
  <p>Thank you.</p>