CONTENT WARNING
This site refers to our older, server-based product. If you are interested in our new, Excel-based product, please see our main web site at http://www.nextanalytics.com
| Reverse |
This function reverses the order of the rows or the columns.
Syntax:Parameters:axis – which axis will be used { Row, Column }Examples:Reverse,Column This example re-arranges the order of the columns to be the opposite of what they are currently.Comments:This function is handy prior to performing a growth operation if the data columns are not in an ascending order time-wise. |
Reference
- Functional Index
- AddAggregates
- AddBaseline
- AddData
- AddPage
- AssignCellFormat
- AssignColumnCSS
- AssignWordsToValues
- AssignWordsToValuesSelectedColumns
- AutoPopulateBaselines
- ChangeAlertTo, Axis
- ChangeAlertTo, CellValue
- ChangeAlertTo, None
- ChangeAlertTo, RelativeCell
- ChangeLabelCaption
- ChangePageProperties2
- ChangeTextInTextColumn
- ChangeValuesAboveBelowAggregation
- ChangeValuesPercents
- ChangeValuesToNTile
- ChangeValuesToRank
- ChangeValuesValues
- ClearOldPages
- ClearSelection
- Combine
- CombineDuplicates
- CombineSimilar / ByIndex
- Compare
- CompareSimilar
- ConcatenatePagesWith
- ConcatenateTextColumns
- ConvertAlertsToData
- CopyDataToTextColumns
- CreateTextColumnFromDateColumn
- DeleteTextColumn
- DistributeCellCollection
- Extract
- FilterByValue
- FilterGlobally
- GetCaption
- GetCountsOfValues
- HidePage
- HidePagesExcept
- ImportData
- ImportDataNoHeader
- InvertSelection
- JoinTwoPagesByMatchingRowLabel
- KeepSelected
- MathOperation
- MathOperationOnTwoPositions
- MoveColumns
- MoveColumnValuesToPages
- MoveRowLabelsToPages
- MoveRows
- MoveTextColumnValuesToPages
- NewRowLabel
- NewStartingPoint
- NewTextColumnName
- PageCaption / PageDescription / PageDescriptionAppend
- PageNumericFormat
- ProjectProperties
- Prompt
- PromptForPage
- Query, Captions
- Query, Command / CommandAppend
- Query, CommandTimeout
- Query, Roles
- Query, RowLabel
- Query, Run, ODBC / Oracle / SQL / JDBC
- Query, RunSave, ODBC / Oracle / SQL / JDBC
- Query, TextColumnNames
- RemoveDate
- RemovePage
- RemoveSelected
- RemoveTextColumnsAndDataColumns
- RepeatDataColumnNames
- RepeatingCalculation
- RepeatTextColumnNames
- RepeatTextColumnValues
- Reverse
- RollingPeriods
- RunScript
- SaveAsProject
- SavePageToCSV
- SavePageToCSVPivot
- SavePageToNOD
- SavePageToXMLCrosstab
- SearchAndSelect
- Select, Cell / Unselect, Cell
- Select, Page
- Select,Row/Column Unselect,Row/Column
- SelectByCaptions
- SelectBySpecificPositions
- SelectRange / UnselectRange
- SetCultureString
- SetMath
- SetTupleValue
- ShowAsNumberStandardDeviations
- ShowPage
- Sort
- SortByDate
- SortColumnLabel
- SortCustom
- SortRowLabel
- SortSelected
- SortTextColumn
- SplitTextColumn
- Swap
- SwapCellValues
- SwapTextColumnWithColumn / ByIndex
- SwapTextColumnWithRowLabel / ByIndex
- Test