Hi Matheus,

I had that. In your most left column, subset data for Period is point to top hierarchy of Period.


Regards,
Yohana

Hi Matheus,

Sorry, i'm not answered it clearly.

Before you go to the steps, i want you to check one thing. Please export your report to excel (with Jedox formula). I assume, your dynarange is generated in that report. Check your formula whether it points to the correct Grupo/Group or not. If you are using Name Range or Variable, try to change it to direct cell address (ex: $B12) in your dynarange and see the result.

I also did this in my dynarange:
1. First you open your first dynarange (in this case "Grupo/Group".
2. Go to Data tab and you might have set it up dynamically, right ?
3. In that Data tab, find Period (since this is your second dynarange, right ?)
4. In Period, choose the top element only.
5. Do a refresh, see in preview pane you still got element to display and save it.

Regards,
Yohana

Hi,
you can't automatically fill cells outside of a DynaRange (in your case, those cells are inside the outer, but outside the inner DynaRange if you know what I mean). Those cells are only created as you expand the inner DR.

If the out DynaRange is not interactive (i.e. if your users are not supposed to expand / collapse stuff there), what you could try is:
- make the outeer DR very narrow / use white on white text, i.e. hide its cells somehow
- move the "master cell" of the inner DynaRange (the one where element names are returned) a column to the left
- add a cell ref to the outer master cell in the inner DR

Attached two screenshots, which hopefully illustrate what I mean