- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table sorting with cumulative sum (RangeSum)
Hi everybody,
I have a table chart containing the Fields Name, Sales and Cumulative Sales. The latter are calculated through RangeSum formula: RangeSum(Above( Sum(Sales), 0, RowNo())). The calculation with RangeSum works fine, but I want the table sorted by Sales.
As soon as I add the Measure for the Cumulative Sales, the sorting switches to alphabetic sorting by name. In the sorting pane, it stills appears to be sorted by Sales, but that is not what is visible in the actual table. Changing the sorting in the sorting pane has no effect on the chart.
Is there a way to solve this problem?
Thank you in advance for any suggestions.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
you can work around it , by changing the sorting of the dimension like this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
you can work around it , by changing the sorting of the dimension like this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much!! It worked perfectly!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi! Same issue in Vizlib table, no option to sort by expression. Do we have any workaround ? Thanks in advance