Forum Discussion
Decomposition tree sort variables and increase node width
Hello clarkson106
if this is what you want,
you need to do the following :
1. create w calculated column to rank the years .
2. create a second caluclated column to rank the sales ( in each year )
create a third caluclated column to concatenate the 2 previosuly created columns .
in the decomposition tree, add this measure in the tooltip ,
then you order by this column .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
- Daniel291952 years agoCommunity Champion
keep in mind, that if you want the ranking to change base on your slicers,
you need to create the sortings as measures not calucalted columns .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠- Daniel291952 years agoCommunity Champion
- clarkson1062 years agoFrequent Visitor
Thanks for the reply. I will test it out and let you know how it goes