Palo Community Forum

I have a list of accounts which needs to be shown in a different sort order, depending on the report.
I tried to solve the problem with a "sorted by" attribute, where I input just an ongoing number to desbribe the sort order.

However, when I try to input a subset with the Excel function and use sort by attribute - it will be sorted by the way I created the elements.

I've attached a little picture of a remodelled sample - just to explain what I want and which formula I use.

Actually I have no idea what I am doing wrong....

Help please!



got it- can be closed. (It only works with Alias and only with text sorting, so numbers must be 1001, 1002, a.s.o....)

[list]
1. Within your dimension attributes create a new attribute called ALIAS.
2. Make the ALIAS attribute consolidated and include the attributes you want to sort by. (these attributes must be text!)
3. When you insert a subset with the subset editor you can select 2 attributes in the basic setting or try it with variable. (If you see no selection when clicking on "1.Alias"-> check step 2 again)
4. In the subset editor choose "sort by" and select Alias.
[/list]

Now it should work.
If you insert a view in Excel showing only the attributes you can easily test it (like the previously posted picture). The sort order will immediately change when you give other values into the attribute cell.


Good Luck!
Lars

I am not quite sure why to report a bug for something that works...
;-)


...but I use the list - because sorting a hierachy makes no real sense to me.


Greets!
Lars