Detailed by Month for multiple cubes, but not grouping together

Harry Sun
Harry Sun Customer, Community Captain
25 Up Votes 10 Comments Name Dropper 5 Likes
edited July 5 in Platform

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

Accepted Answers

  • Willians Santana
    Willians Santana Employee
    Second Anniversary 5 Answers 10 Comments Level 100: Foundations of Building in Board
    Answer ✓

    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
    Willians Santana Employee
    Second Anniversary 5 Answers 10 Comments Level 100: Foundations of Building in Board
    Answer ✓

    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

Answers

  • Harry Sun
    Harry Sun Customer, Community Captain
    25 Up Votes 10 Comments Name Dropper 5 Likes

    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