2 Replies Latest reply on Aug 21, 2012 11:25 PM by Viswanath Sankar

    Calculation for each level in the hierarchy

    Viswanath Sankar

      Can someone help me write a calculation which will have different values for each level of a hierarchy.


      i.e. if we have hierarchy with 3 levels, I would need the measure A to be displayed when I see data at the top level, measure B when I drill down to level 2 and measure C when I drill down to level 3.


      I have tried using ATTR() and Count() functions but they fail when I have just one member in all 3 levels. Even if there is just one member for all the 3 levels, the drill down should show the corresponding measures.


      Any help is highly appreciated.