I have a question regarding a formatting issue that occurred after applying a rule to a data block. I created a custom sort order for an entity. In my data view, the entity is used as an axis for the columns. While using certain cubes to populate the data, the custom sort order displayed correctly.
However, I noticed that the consolidated columns were not being populated with data. To address this, I applied a rule to the data blocks, which resolved the data flow issue. The challenge now is that after applying this rule, the custom sort order for the entity is no longer being respected—the columns are displaying in a different order.
What might be causing this behavior? Is there a way to maintain the custom sort order for entity while still applying the rule to the data block?