#COE#SW01 How to show a field in all rows?

[israelpsalas]

Hello,

We would like to have the field Company code shown in all rows instead of having the values merged. For example, in app "Trial balance" as you can see below, we have merges all rows that are for the same company code but for analytical purposes we would need them to be shown in each line:

In SAC for example, the name of this functionality is called "Repeat member".

Could you help us?

Thank you.

Israel Palomo Salas

[OwenLiu]

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

[Batista · Accepted solution]

step 1

step 2

step 3

step 4

[junaidalam]

thiagoholanda.cavalcante - I think Sandra has suggested the best way forward for your scenario. You may open a customer Influence request and explain your business case in that.

Influence Request for SAP

[Batista]

hi

the only way I found to have something similar is to remove the attribute, then add it again (remove display totals) and save this under my bookmark. The order is switched...

not sure if there are other options...

[former_member327370]

Hello,

You have mentioned an example below, but it seems to be missing here.

[Batista]

Update: 2202 release will bring no cell merge option for multidimensional reports which will support the requirement asked in this question.

Thank you

[thcavalcantesdw]

Hi Sandra,

Thanks for the explanation and the steps.

Unfortunately this steps work only if you keep the column in the 2nd position. Moving the column to the original position, the data is merged again.

I tried to remove all the columns and add again but it does not work as well.

Thanks.

[Batista]

Hi

I could find an option by adjusting drilldown options. I am not aware of other options. See steps.

Screens below are from internal test system

step 1 In company code – right click – option drilldown/remove drilldown

result

step 2 Then, under G/L account, right click, select Add drilldown Company code

step 3 Select hide totals

Final result

step 4 bookmark - bookmark so that in next run, can select and see as above

hope helps

[israelpsalas]

Hello this column: "Company code", we would like to have the value in each row instead of merging all the lines for the same company code.