3 Replies Latest reply: Jan 31, 2018 1:16 AM by Kaushik Solanki RSS

    Expression for Heirarchy

    Rajeshree Bhangale

      Hi All,

       

      I am having difficulty in writing an expression for heirarchy.

       

      The requirement is, I have a heirarchy (having 4 dimensions - zone, state, district,office) as my dimension in the (treemap) chart. I have to write an expression for sales in such a way that  for Zone and state sales will be in TMT which is sum(sales)/1000 and for district and office sales will be in MT which is sum(sales). Problem is how to split this Heirarchy in expression editor.

       

      Let me know if you have any idea to get this.

       

      Thanks!