Tagged with sorting - Visokio Forums http://forums.visokio.com/discussions/tagged/sorting/feed.rss Mon, 30 Oct 17 15:50:02 -0400 Tagged with sorting - Visokio Forums en-CA Pivot view: Sorting Column Headers in descending date order http://forums.visokio.com/discussion/3105/pivot-view-sorting-column-headers-in-descending-date-order Mon, 07 Mar 2016 06:39:47 -0500 dabay 3105@/discussions
I have a pivot view that has the date columns along the x-axis, is there a way to sort the columns in descending order so the latest date appears as the left most column. Below is the screenshot of the original report where it only orders the dates in ascending order.

image]]>
Idea: Table View - Sorting 'Grouped' values? http://forums.visokio.com/discussion/1949/idea-table-view-sorting-grouped-valuess Fri, 14 Dec 2012 04:25:49 -0500 acohen 1949@/discussions
At the moment, if you sort on a field that is Grouped, the sort occurs at granular un-grouped level and hence is not useful for the end-user. I find that I hardly ever use the grouping functionality because of this.

Can we make it so that when you click on a column that is grouped the sort occurs at the grouped level and then when you expand the table (and click again) the sorting will then occur at the expanded level?

This functionality, although simple, would make a massive difference in terms of usability and report design impacting on almost all of our reports.

Thank you,]]>
Filtering: Dynamic rankings in a filtered view? http://forums.visokio.com/discussion/2821/filtering-dynamic-rankings-in-a-filtered-views Wed, 21 Jan 2015 03:15:25 -0500 nash 2821@/discussions At the same time I need to calculate what is the share of the every of these three brands of all the brands which are selected.
And the last requirement is to show the difference for every brand to the year before.

So far I work it out for all brand which are in the data with formulas in the fields.
However I would need more dynamic.

Is there a way to get it are you working on it?]]>
Pivot View: Sorting and Ranking aggregated records/fields? http://forums.visokio.com/discussion/2705/pivot-view-sorting-and-ranking-aggregated-recordsfieldss Mon, 01 Sep 2014 07:22:52 -0400 tagarw 2705@/discussions Please see attachment for the problem and help me with this. Let me know if you need more information.
]]>
Sorting: Mondays first in Table View? http://forums.visokio.com/discussion/2574/sorting-mondays-first-in-table-views Thu, 29 May 2014 08:01:07 -0400 Panos 2574@/discussions
Thanks, Panos]]>
Data type: Integer, Date or Category http://forums.visokio.com/discussion/2515/data-type-integer-date-or-category Mon, 14 Apr 2014 15:34:38 -0400 TomRiggs 2515@/discussions Table View: Sort by grouped totals? http://forums.visokio.com/discussion/2113/table-view-sort-by-grouped-totalss Mon, 29 Apr 2013 11:30:13 -0400 Mees 2113@/discussions Sorting a column in a grouped table works not as expected... it sorts the underlying records (I assume).
We would want sorting the values you see in front of you, the totals...?

Thanks, A]]>
Formulae: RUNNINGTOTAL sorting issue? http://forums.visokio.com/discussion/2082/formulae-runningtotal-sorting-issues Thu, 04 Apr 2013 09:07:03 -0400 cpvk 2082@/discussions
I have a question on the function RUNNINGTOTAL, and wondering if anyone could help.

I want to add Sales cash cumulatively by week for a particular SKU/Year combination.

I have the following formula in a field called "Cumulative Spend"

RUNNINGTOTAL([Sales Cash],SUBSET2([Sku],[Year]),false)

So this adds by year/SKU, but not in the right week order. I've tried to do a sort on the data-set to help. But was wondering if there was a smarter way. I have just downloaded the latest 2.8 version this morning.

Basically, it sort of works, but it doesn't add in Week order. Is there any way to make this happen?

Thanks]]>
DataManager: Sorting 1000s of Fields/Columns alphabetically? http://forums.visokio.com/discussion/2005/datamanager-sorting-1000s-of-fieldscolumns-alphabeticallys Wed, 06 Feb 2013 11:13:44 -0500 davedunckley 2005@/discussions Bar/Line View: Sorting bucketed numeric data? http://forums.visokio.com/discussion/1896/barline-view-sorting-bucketed-numeric-datas Tue, 13 Nov 2012 11:24:10 -0500 earheart 1896@/discussions Table View: sort by grouped subtotals? http://forums.visokio.com/discussion/1892/table-view-sort-by-grouped-subtotalss Sun, 11 Nov 2012 10:52:51 -0500 Alexander 1892@/discussions Am I doing something wrong or is this not possible? Thanks!]]>