Detailed by Month for multiple cubes, but not grouping together

Harry Sun · 2024-07-04T23:03:45+00:00

There was an error rendering this rich post.

Hi BOARD Team,

I am not using By COLUMN as month so I can have Block a (SOH) only showing once.

I use Detailed by Month for all other block, so other blocks will be detailed and grouped by Month.

However, block g (algorithm) and h (blank use as divider) are not grouped by month. Those two blocks are showing at the back of the table. Could you please let me know how can I make this work? Thanks

Find more posts tagged with

Accepted answers

Willians Santana

Hi @Harry Sun . I hope you are having a great day!

Thank you for all the information provided! I do appreciate that.

What is the output goal of this layout?

Have you added the Entity Month as a block in the layout?

Kind Regards,
Willians

Willians Santana

Hi @Harry Sun,

Thank you for your message and all the details provided! I do appreciate that.

If you disable Row Totals, does it work for you?

If not, please, send a message to wsantana@board.com, so we can have a remote session to review the layout.

Kind Regards,

Willians

All comments

Willians Santana

Hi @Harry Sun . I hope you are having a great day!

Thank you for all the information provided! I do appreciate that.

What is the output goal of this layout?

Have you added the Entity Month as a block in the layout?

Kind Regards,
Willians

Harry Sun

Hi Williams,

I want to achieve a layout like this. SOH only showing once, then everything else will group by months.

I did not put month under column, so I can get SOH showing once only. Then I Detailed by Month for all other columns. All columns grouped by month ok, expect Month Cover and the Divider column.

This is how it looks like after I detailed by month. I tried to move the data block to different sequence, but those two columns always played up and not grouping by month as expected.

Thanks

Willians Santana

Hi @Harry Sun,

Thank you for your message and all the details provided! I do appreciate that.

If you disable Row Totals, does it work for you?

If not, please, send a message to wsantana@board.com, so we can have a remote session to review the layout.

Kind Regards,

Willians