In the qvw file I attach, how would I sort dimension a of the graph based on the % value of b = 1 in descending order. So looking at the blue bars where b = 1, they have different heights. I want to sort the graph so that the a dimension goes from 2018, 2015, 2017, 2016 in this order from left to right. After rearranging the a dimension values like this, you'll see that the blue bars where b = 1 are sorted in descending order. Note that all the other values in b do not matter in this, and I would like to keep the values of b in ascending order. Is there anyway to do this?
you want to sort the chart by sum(val) for b=1 in descending order? Goto sorting tab, for a i defin ethe formula =sum({<b={1}>} val) / sum({<b={1,3,5,7,9}>} total <a> val) in descending order for b I untag everything. you may define your sorting order for b
you want to sort the chart by sum(val) for b=1 in descending order? Goto sorting tab, for a i defin ethe formula =sum({<b={1}>} val) / sum({<b={1,3,5,7,9}>} total <a> val) in descending order for b I untag everything. you may define your sorting order for b
