Dienstag, 8. Dezember 2015

Analysis Office: How to work with Excel formulas

In Analysis Office 2.2 a new feature was published. You can now use your own Excel formulas in a Crosstab. First you have to add a row or column in your Crosstab. The table design is a feature since Analysis Office 2.0.


You can add your formula.


Then you can drag your formula down to the end of the Crosstab.


When you now add a new characteristic to the rows, you will see the Excel formula will be automatically adjusts.