Sorting on secondary dimension

[#1]

Hi,

I have two dimension -Year and a Cyclic group(Category,Product) in a stacked bar chart and sum of Sales in expression.

I want to apply sorting on the dimensions based on the expression. It worked for first dimension alone second dimension is not getting sorted by the expression.

Please help me on this

[amars]

Hi ,

You can use Sort by Y-value & can keep it Sort by Ascending or desnding value..

thanks.

[#3]

Thanks for ur reply. But this option is not enabled for the "Second dimension"

[#4]

Hi ,

You can sort both the dimensions which you have created.

1. For the dimension Year : You can change directly from Sort Tab in the properties.

2. For the dimension Cyclic group : Chart Properties - Edit Group - Edit - SortOrder.

For Cyclic group you have option ' SORTORDER ' to sort individual dimensions used in the group.

Regards

BhargavRaj

[#5]

Thanks for ur reply. I tried it already. I want to sort the cyclic group based on the expression. But it is not working as expected.

[#6]

Hi, unfortunately you cannot have an individual sorting order for each group of stacked bars. 🙂 With the sorting expression that you have for your cyclic group, it will take the sum of all sales and put that category or product on the top. The sorting expression is evaluated once prior to visualization.

[prieper]

You *can* determine the sortorder by entering an expressions - should be ideally same as in the graph.

HTH
Peter

[#8]

That's done already, if you check the attached file in the original post. The goal here is to sort each group of stacked bars separately, and that *cannot* be done in QV. 🙂

[prieper]

you are correct

Peter