Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Drill Down hierarchies

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

 

 

No Replies