Forum Discussion

tyagiyash32's avatar
tyagiyash32
Helper I
7 years ago

Hierarchy

Hi, i am facing issues in using the drill down option, my data is as follows; i need to put a bar chart with countries in axis vs values M & L, where M is ((M1+M2+M3+M4+M5+M6)/6)/X and L is ((L1+L2+L3+L4)/4)X. Now the thing is that i need to drill down at M so that the next level shown is M1, M2, M3, M4, M5, M6, similarly when i drill down at L it should show the next level as L1, L2, L3, L4. Please can anyone have a clue on how to do it?

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi tyagiyash32 ,

     

    Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

    Regards,

    Frank

    • tyagiyash32's avatar
      tyagiyash32
      Helper I
      7 years ago

      Hi, 

      the data is as shown in image:

       

      so in a barchart on axis as region and country (drill down) & on values it shoud reflect the calculated measure, i.e. M, L1. That drill down easily shows region name>country name> and their respective M & L1 values, but I need to drill down that to lower levels to reflect MS, MG, MLa, M Lo,... so on and same for L1 vakues. Sysdate is the date filter.