Drill Down hierarchies

[Anonymous]

Hello,

I have a situation where I need to 'drill down' three levels.  The fields that I'm attempting to drill down are as follows:

• Level_Name
  
  • Fundraiser
  • Organization Position
  • Organization Team
• Level Value
  • Fundraiser 1
  • Fundraiser 2
  • MDOD
  • Director (Top level)
  • Name 1
  • Name 2
• Target
• Current YTD
• Previous YTD
• Prior YTD

The Organization Team can be a Director and MDOD

The Organization Position can be Fundraiser 1 and 2 as well as Director and MDOD

The Fundraiser are either Name 1 and Name 2

Basically I'm trying to drill down to the different levels for Target, Current YTD, Previous YTD and Prior YTD for each category.

How would I accomplish something like this?

Thank you for your help