Order with detailed by Selection

Maik Burghardt · 2025-01-09T15:52:19+00:00

There was an error rendering this rich post.

Hi there,

In a data view i have 2 cubes and right after it a algorithm. All are detailed by an Entity.

In the display of the report I can see by status RN / REV for the first status and then comes the next status. However the ADR is shown at the end not grouped into the statuses as with RN and REV.

Any idea how to show RN / Rev / ADR for Room Status 1 and the same grouping for Room Status 2?

Thanks, maik

Find more posts tagged with

Accepted answers

Filip Rankovic

Hi Maik

If possible with the rest of the Layout, it is best to use the "Room Status" in the "By Column" axis definition. This would give the desired outcome, directly:

Otherwise, the algorithm with "Detail by" within subsequent blocks with "Detail by" activated behaves differently when it is the first block among those using it.

As an example, with the downside being that "ADR" is now first within the groupings:

Hope this helps!

Best regards,
Filip

All comments

Filip Rankovic

Hi Maik

If possible with the rest of the Layout, it is best to use the "Room Status" in the "By Column" axis definition. This would give the desired outcome, directly:

Otherwise, the algorithm with "Detail by" within subsequent blocks with "Detail by" activated behaves differently when it is the first block among those using it.

As an example, with the downside being that "ADR" is now first within the groupings:

Hope this helps!

Best regards,
Filip

Maik Burghardt

Understand the explanation but it doesn't make sense.

when having the status as "By column" it duplicates all data items. also those ones which i don't want to show by status.

Helmut Heimann

https://community.board.com/discussion/comment/19416#Comment_19416

Hi @Maik Burghardt ,

in that case, probably the tick with "Show all" on the columns is set ;-) Try to switch that off.

Best,
Helmut

Maik Burghardt

It doesn't do the trick and I went for the second option @Filip Rankovic mentioned.

Thanks all