This is a means to perform an aggregation on a set of rows or columns. Usually it is preceded by a selection operation, or the default of all is used.
Syntax:
Combine, axis, aggregation, selectionMode, selectedKeepRemove, unselectedKeepRemove, caption, boolUseAsTrend
Parameters:
axis – which axis will be combined { Row, Column }
aggregation – the function to be used in the combine ( Average, Sum, Maximum, Minimum, First, Last, Median)
selectionMode – to be included in operation { Selected, UnSelected, SelectedDefaultToAll }
selectedKeepRemove – action to be taken on selected items { Keep, Remove }
unselectedKeepRemove – action to be taken on unselected items { Keep, Remove }
caption – caption text for the newly-created row or column
boolUseAsTrend – use the results for trend testing with the Test command (true) or not (false)
Examples:
Combine,Row,Maximum,SelectedDefaultToAll,Keep,Keep,Max,false
This example uses the selection state of the rows, or defaults to all if none are selected, to calculate the maximum value in each data column, and to add a new row with those values labeled “Max”.
Combine,Column,Average,UnSelected,Keep,Remove,The Rest,false
Calculate the average of all unselected columns, remove those columns, and label the new column “The Rest”. This is a convenient way of removing a large set of records which aren’t very interesting individually but it is desirable to keep the average of them as a group.
Combine,Row,Sum,UnSelected,Keep,Remove,The Rest,false
The unselected rows will be summed, removed and the new row labeled ‘The Rest”. This is convenient when data has been ranked, and the intent is to render only the top few and show The Rest as a group while keeping the totals consistent.
|
