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)
Month | Written Premium (SUM)
Policy Number | Insured Name | Written Premium (SUM)
I have not seen any option to differentiate the columns shown at the various drill down levels.
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.
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