Forum Discussion

clarkson106's avatar
clarkson106
Frequent Visitor
2 years ago

Decomposition tree sort variables and increase node width

I am using Direct query and have a decomposition tree like below. 1. I want the variable Year to be sorted in ascending order by year and not the number of sales in year. So in the example the resul...
Need Help
Tips and Tricks
sayaliredij's avatar
sayaliredij
Solution Sage
2 years ago

Hi clarkson106 ,

1. For sorting . please click on 3 dots and select sort by option select your desired sorting attribute

 

 

 

2. For showing whole name intstead of ....

Please go in formatting options 

select Options

and increse the size.

Thanks and Regards,

 

Sayali

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

clarkson106's avatar
clarkson106
Frequent Visitor
2 years ago

Thanks sayaliredij. Sorry I had not made it clear in my post. So what I want is, whenever the variable Year is added into the tree it should be displayed as 2018, 2019, 2020 so on. But the other variables should be displayed sorted by the number of Sales. If I go with your suggestion of sorting by year, then all other variables are also sorted by year. I only want Year to be sorted by year and all other variables to be sorted by the number of sales. Is this possible?