How to have measures in between dimensions in SAC Table widget?

[anmolbansal7]

Hello SAP Community,

I am currently working on a project where I need to customize the layout of a table in SAP Analytics Cloud (SAC). Specifically, I am required to position a measure between two dimensions in the table widget.

For instance, the default setup is as follows: Company Code, G/L Account, and Amount in TC. However, I need to rearrange it to: Company Code, Amount in TC, and G/L Account.

I understand that using a Measure-Based Dimension in a Calculated Dimension can achieve this.

 However, my challenge lies in the fact that my SAC table has numerous columns, and I'm unsure how to decide which columns should be included in the Dimension Context. If I add all the columns, it results in ‘null’ appearing in the calculated measure-based dimension.

Could you please guide me on how to efficiently determine which columns should be part of the Dimension Context, or if there's an alternative method to achieve the desired column arrangement without encountering null values?

For Reference:

[William_Yu]

Not sure what does this 'position a measure between two dimensions in the table widget' mean. Maybe it's better to provid an expected table layout.

[anmolbansal7]

@William_Yu
For your reference:

[William_Yu]

No, that's not supported by SAC table. 

[Kumar71]

There can be a workaround using Measure Based Dimensions but the tricky part is the Dimension Context, you have to take only those dimensions that are there in Table.

[anmolbansal7]

@Kumar71, I tried taking all the dimensions (which are there in table) as the dimension context. The problem however is it works for a table with small number of columns, my table has 72 columns and if I select all 72, then it shows null in the calculated dimension.