Adding columns at different drill down levels

I am trying to create a report that shows additional columns at lower levels of the drill down hierarchy.  This is how my hierarchy is set up:



I would like to set up my drill down with these columns

Year | Written Premium (SUM)
Drill Down
Month | Written Premium (SUM)
Drill Down
Policy Number | Insured Name | Written Premium (SUM)


I have not seen any option to differentiate the columns shown at the various drill down levels. 

2 replies

    • Yakov_Shaul
    • 6 yrs ago
    • Reported - view

    Can you please clarify?

    Are you trying to drill down (move from a parent to its children on a hierarchy with multiple levels?

    or simply show subtotals?

    If it's the latter, you'll need to select multiple attribute hierarchies, then add subtotals. (see image)

    Let us know if it helps.

    • Nikos_Volakakis.1
    • 6 yrs ago
    • Reported - view

    Cory Bowles Hi Cory , are you interested in a MDX solution? In case you want to create a custom member make 2.

    1) written premium (sum
    2) insured name:
    Iif([your hiererchy Name].LEVEL.name = 'PolicyNumber', [Measures].[Insured Name], NULL)

    Give it a try



Content aside

  • Status Answered
  • 6 yrs agoLast active
  • 2Replies
  • 58Views
  • 4 Following