Frequently asked questions for self help.
Knowledge base article 89How about pivot tables
There is no "Pivot" function built into this version of Ability. We have however written a simple macro that can be used to turn column information into a pivot table (or cross-tabulation). To see an example, download and open the following spreadsheet:
To use the code in this example for all spreadsheets:
- Open pivot.aws
- Select Tools/Macro/Macro Editor
- Open up the code in the pivot.aws Macro Module
- Select all the code and Copy
- Paste into the Application Macro Module
The macro "Pivot" can now be used in any spreadsheet.
Feedback on the above most welcome - please send to firstname.lastname@example.org