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.

Excel formula in Analysis Office Crosstab
Excel formula in Analysis Office Crosstab

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

Expand Excel formula in Analysis Office Crosstab
Expand Excel formula in Analysis Office Crosstab

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

Expand Excel formula in Analysis Office Crosstab
Expand Excel formula in Analysis Office Crosstab
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0