This content has been marked as final. Show 3 replies
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.