Flexgrid order columns

Maik Burghardt

Hi any idea how to cluster all columns by year?

It doesn't work for the calculated column for all years.

Thanks Maik

John Williams

@Maik Burghardt

Hello! I can certainly help you troubleshoot the column clustering issue you're seeing in your Flex Grid.

It looks like you're correctly trying to use the Year entity to group all your measures—including the standard sums and the Calculated(ADR) field—under the respective year headers. This is the core functionality of Pivoting and Grouping in the Flex Grid, but sometimes the setup can be tricky, especially with calculated fields.

Here is the solution and the likely reason the calculated column isn't working as expected, based on the Flex Grid documentation:

How to Cluster All Columns by Year (Solution)

To ensure the clustering works for every column, you must explicitly set the Year Entity as the top-level Column Label using the Flex Grid's configuration features:

1. Enter Design Mode: Make sure you are in the screen's Design Mode to access the Flex Grid configuration.
2. Ensure Pivot Mode is On: You need to Toggle Pivot Mode to enable grouping by columns.
3. Verify Field Placement: In the Fields Panel, check the Column Labels section (this appears only when Pivot Mode is on).
   • Year Entity must be dragged into and placed in the Column Labels section.
   • Year Entity should be the highest-level grouping (usually at the top of the list in the Column Labels section) to ensure everything beneath it is clustered by the year.

Why the Calculated Column Might Not Be Clustering

Your screenshot suggests the configuration is almost right, as the regular sums (e.g., Sum(RN), Sum(Rev)) are repeating for each year. If Calculated(ADR) is the only one not working, here is the most probable cause:

The Flex Grid allows users to easily manipulate data fields. Sometimes, when adding a new or calculated field, it doesn't automatically get recognized as part of the same dimensional grouping as the others.

Action to Take:

• Explicitly Drag the Calculated Field: Open the Fields Panel and look for the Calculated(ADR) field. Make sure it is defined as a Measure and is grouped correctly with the other measures, or simply drag it directly into the relevant section of the grid's measure area.
• Check the Underlying Definition: Because Calculated(ADR) is a calculated field, its definition might not be dimensionalized by the 'Year' Entity in the underlying Cube or Algorithm. If the calculation itself doesn't account for the Year dimension, the Flex Grid might not be able to pivot it correctly alongside the other Year-based columns. You may need to review the formula for that calculation outside of the Flex Grid object.

Let me know if moving the Year field in the Column Labels section resolves the issue!