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

Expression for Heirarchy

Rajeshree Bhangale Jan 30, 2018 10:46 PM

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!

Re: Expression for Heirarchy

Kaushik Solanki Jan 31, 2018 12:01 AM (in response to Rajeshree Bhangale)

Hi,

When you say Hierarchy, is it that you have created a drill down dimension? or you have 4 different dimensions?

Regards,
Kaushik Solanki
Like Show 0 Likes (0)

Actions
- Re: Expression for Heirarchy
  
  Rajeshree Bhangale Jan 31, 2018 1:03 AM (in response to Kaushik Solanki )
  
  Its a drill down dimension.
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Expression for Heirarchy
    
    Kaushik Solanki Jan 31, 2018 1:16 AM (in response to Rajeshree Bhangale)
    
    You Can create a variable which holds the value you want to divide.
    
    Say for example vDivide
    
    vDivide = If(Getselectedcount(Office)>=1,1, If(Getselectedcount(District)>=1,1,1000))
    
    Now divide your expression with variable
    Sum(Sales)/$(vDivide)
    
    Regards,
    Kaushik Solanki
    
    Like Show 0 Likes (0)
    
    Actions

Go to original post