Hierarchy with non aggregated values

Hello,

Is there a way to display a non-aggregated value for each bar in the following chart without using legend (we have 257 rows and a business requirement to transverse the graph following the hierarchy using drill down function).

I have 257 business areas, all with 4 digit codes and a parent child relationship via these codes. I have taken these codes and implemented the following calculated table using PATH functions:

I have created 2 measures:

Maxdepth = MAX(hierarchydepth)

Browsedepth = isfiltered(level2) + isfiltered(level3)+...isfiltered(level8)

I have created a hierarchy using the level 2 to level 8 columns

My sales table has the following columns and is related to the hierarchy table via cost centre column:

For each of the 257 rows in the hierarchy table I want to fetch the YTD vs plan % column value. At the top of the hierarchy I have 1 cost centre which I need this value for without it aggregating the value due to the hierarchy and display this as a bar graph. I have the drill down working as required, I can click on this 1 cost centre at level 2 and then it opens all level 3 cost centres related to this one etc. However it is aggregating the YTD vs plan %. I need it to just display the value related to that cost centre and not the sum/avg of all the cost centres underneath it.