topic Drill Down hierarchies in Developer https://community.fabric.microsoft.com/t5/Developer/Drill-Down-hierarchies/m-p/746719#M20082 <P>Hello,</P><P>&nbsp;</P><P>I have a situation where I need to 'drill down' three levels.&nbsp; The fields that I'm attempting to drill down are as follows:</P><P>&nbsp;</P><UL><LI>Level_Name<BR /><UL><LI>Fundraiser</LI><LI>Organization Position</LI><LI>Organization Team</LI></UL></LI><LI>Level Value<UL><LI>Fundraiser 1</LI><LI>Fundraiser 2</LI><LI>MDOD</LI><LI>Director (Top level)</LI><LI>Name 1</LI><LI>Name 2</LI></UL></LI><LI>Target</LI><LI>Current YTD</LI><LI>Previous YTD</LI><LI>Prior YTD</LI></UL><P>The Organization Team can be a Director and MDOD</P><P>The Organization Position can be Fundraiser 1 and 2 as well as Director and MDOD</P><P>The Fundraiser are either Name 1 and Name 2</P><P>&nbsp;</P><P>Basically I'm trying to drill down to the different levels for Target, Current YTD, Previous YTD and Prior YTD for each category.</P><P>&nbsp;</P><P>How would I accomplish something like this?</P><P>&nbsp;</P><P>Thank you for your help</P><P>&nbsp;</P><P>&nbsp;</P><P><IMG src="https://community.fabric.microsoft.com/computer" border="0" alt="" /></P> Tue, 23 Jul 2019 12:33:18 GMT Anonymous 2019-07-23T12:33:18Z Drill Down hierarchies https://community.fabric.microsoft.com/t5/Developer/Drill-Down-hierarchies/m-p/746719#M20082 <P>Hello,</P><P>&nbsp;</P><P>I have a situation where I need to 'drill down' three levels.&nbsp; The fields that I'm attempting to drill down are as follows:</P><P>&nbsp;</P><UL><LI>Level_Name<BR /><UL><LI>Fundraiser</LI><LI>Organization Position</LI><LI>Organization Team</LI></UL></LI><LI>Level Value<UL><LI>Fundraiser 1</LI><LI>Fundraiser 2</LI><LI>MDOD</LI><LI>Director (Top level)</LI><LI>Name 1</LI><LI>Name 2</LI></UL></LI><LI>Target</LI><LI>Current YTD</LI><LI>Previous YTD</LI><LI>Prior YTD</LI></UL><P>The Organization Team can be a Director and MDOD</P><P>The Organization Position can be Fundraiser 1 and 2 as well as Director and MDOD</P><P>The Fundraiser are either Name 1 and Name 2</P><P>&nbsp;</P><P>Basically I'm trying to drill down to the different levels for Target, Current YTD, Previous YTD and Prior YTD for each category.</P><P>&nbsp;</P><P>How would I accomplish something like this?</P><P>&nbsp;</P><P>Thank you for your help</P><P>&nbsp;</P><P>&nbsp;</P><P><IMG src="https://community.fabric.microsoft.com/computer" border="0" alt="" /></P> Tue, 23 Jul 2019 12:33:18 GMT https://community.fabric.microsoft.com/t5/Developer/Drill-Down-hierarchies/m-p/746719#M20082 Anonymous 2019-07-23T12:33:18Z