Skip to Content

AO Formulas with reference outside SAPCrosstab

Oct 31, 2017 at 08:04 AM


avatar image

Hi Everyone,

I would like to know if it's possible to add a formulas with dynamic reference outside a SAPCrosstab.

For exemple If my Crosstab Is positionned between columns C and E.

Is it possible to create a new column (col D) with a dynamic Reference to column A (with a formulas like D4 = A4 * 2). I tried to do this but the reference to colA is static, so I get D33 = A4*2 instead of A33*2)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Oct 31, 2017 at 11:24 AM

Alicia - not sure I follow, but I believe there are enhancements coming for later this year - see

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy ,

Thanks for your answer, I'm not sure that this requirement is listed in the futur enhancements of the doc.

The purpose is to create a dynamic formulas (one formulas for all the entire colum "Ratio3") in SAPCrosstab2 that has a reference either to SAPCrosstab1 (first print screen) or Excel data outside of the crosstabs (second print screen)

For the moment we are using one formulas per cell, It's working fine as long as we don't have more than a 100 formulas. After this it seems that the formulas are not taken into account. Is there a known restriction about the amount of formulas that can be used ?



wusu3.png (55.9 kB)

Hi Alicia - I am not aware of any written restriction

Are you using Analysis Office 2.5 SP02?



We are using Analysis for Office 2.4.1


Hi Alicia - any chance you could try this with 2.5 SP2 - this is the latest GA release

Tammy Powlas
Nov 02, 2017 at 09:29 PM

Alicia - this should work, I think, in 2.5 - please see this screen shot from the SAP Learning Hub:

Source: SAP

alicia2.jpg (240.1 kB)
10 |10000 characters needed characters left characters exceeded