cancel
Showing results for 
Search instead for 
Did you mean: 

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

anmolbansal7
Explorer
0 Kudos
131

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.

image (6).jpg

 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:

anmolbansal7_0-1744639480938.png

 

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

No, that's not supported by SAC table. 

Kumar71
Newcomer
0 Kudos
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
Explorer
0 Kudos
@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.