Skip to Content
Mar 23, 2015 at 06:17 PM

BPC 7.5 NW : Cell Reference PageKeyRange


Dear Experts,

I am trying a very simple thing I already implemented in other reports but is not working this time.

I want to define a member in the PageKeyRange based on a cell reference.

The user selects a version of the budget in a dropdown list via its description. Then I have a table and a VLOOKUP formula to define the ID.

Then the PageKeyRange refers to the VLOOKUP formula.

The issue is, the report won't expand according to the selection.

However, if I hardcode the member in the PageKeyRange, everything works fine.

Do you have any idea about what is happening?