Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to order my table, but i don't understand why can't i do this.
Dimension:
CAUSA
Measure1:
Count(CAUSA)
Measure2:
Rangesum( Above( COUNT(CAUSA)/count( ALL CAUSA),0,Rowno(Total)))
Table:
Hi Eduardo,
When you add rangesum(above..) expression to table or table equivalent chart, you can not do ordering over other measures, not dimensions. Dimensions keep working on ordering.
But you can order over measures by using a workaround. Define your measures like a dimension. I know it not the best practice but it is working as you wish
Sorted over first dimension:
Sorted over measure and not working:
Sorted over a dimension which is created to show measure value and working:
You should edit your rangesum expression a bit after making these changes
RangeSum(Above(total sum(QTY)/sum(total QTY),0,RowNo(total)))
P.S : After creating this dimension, you should also change its ordering type from auto to custom(Sort numerically) over table properties panel.
Hope it helps...
Hi
response above in not fully correct. The reason why sorting is disabled is because of RowNo() function "Sorting on y-values in charts or sorting by expression columns in tables is not allowed when RowNo() is used in any of the chart's expressions. These sort alternatives are therefore automatically disabled."
Thanks for the correction and tip David. I didn't know that rowNo() function causes this behavior. It is good to know
But that workaround solution still seems valid
Hi David, thank you for this explanation. But i can't ordinate even if i not use RowNo(). Only when i remove above() that i can ordinate again
Hi Kaan, nice workaround, but what i need are the accumulated values from that table in crescent order like:
Value in order | Accumulated Value |
---|---|
5 | 5 |
7 | 12 |
12 | 24 |
Is that a better way to get this withou workaround or RowNo() ?