Dynamically change dimension levels in crosstab row

[acabugason]

Is there a way to dyamically change the dimension levels in a crosstab row?

I'm trying to create a report wherein the dimension level in the crosstab row dynamically changes based on the user. For instance, I have users A, B, & C. User A has access to Level 1 of dimension XYZ; user B, Level 2; and user C Level 3. Dimension XYZ is the row dimension for my crosstab. What I'd like is for that crosstab row to display one level below a user's permission. So, when user A runs the report, the crosstab row should show Level 2 of dimension XYZ.

I have tried a couple of solutions to no avail. I tried using a macro -- #'[dimension].[hierarchy].[level]'# -- where I tried to replace '[level]' with a data item, then I also tried using the levels expression -- levels([dimension].[hierarchy],index) -- where I tried to put a data item in place of the index. Neither one worked.

Am I on the right track? If so, where am I going wrong? If not, how should i tackle this problem?

Thanks!