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:
YearBooked
MonthOfYear
PolicyNumber
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
-
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 tryNikos
