Forum Discussion

HassanI's avatar
HassanI
Frequent Visitor
8 years ago

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 hi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI HassanI,

 

After I remove non existent child code and rebuild hierarchy, your visual graph can be drilled again.

 

Regards,

Xiaoxin Sheng

HassanI's avatar
HassanI
Frequent Visitor
8 years ago

Hi as I mentioned, the drillthrough was already working fine, the issue was the values field "YTD vs plan %". If I'm looking at level 1 we have one code 4911, it's YTD vs Plan % in the data is -1.85% which is the value I want to display against 4911. Not the aggregated value of everything under it. When I click to drilldown on 4911 it opens level 2 cost centres related to 4911 such as 4216, 4428, 5691....and so on. For each of these i want to pull the specific ytd vs plan % not the aggregated value.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi HassanI,

     

    I don't think this issue simple to achieve, visuals will auto summary it's child values.

     

    For your requirement, you need to add condition to check current hierarchy levels, then break current summary and manually coding formula to get specific value with filters to get data from particular level.

     

    It should be complex and hard coding.

     

    Regards,

    Xiaoxin Sheng