Cell Summary Demo

Use Cell Summary to see summary information about a group of selected cells using a variety of mathematical operations.

AdapTable ships with a number of 'Summary Operations' that you can use (some of which work only on numeric columns) and you can provide your bespoke summaries.

Try it: highlight a group of cells and see the value change in the Cell Summmary toolbar. Click the 'info' button to see results of all operations or change the selected one by using the dropdown.

Note that the dropdown includes 3 financial summaries ('WeightedAverage', 'VWAP' and 'Only'); this is beause we installed the Financial plugin (one of the Plugins that AdapTable provides).

To create a Summary Operation: provide the name of the function, which will be evaluated each time the summary is run, in Cell Summary State and the actual implementation in UserFunctions.

In this example we have provided an 'Oldest' function which runs only on Date columns and returns the oldest date in the selection.

Generating dummy data, please wait ...