Table - how to get account number and account name on the same line ?

[Bertrand_fr]

Hi everybody,

I would simply like to have a table with:

- Country appearing once and not on every line

- account number

- account name

When I do this with table, I get the country name appearing on every line (1st pic).

When I do this with cross table (2nd pic), I get a sublevel between account number and account name.

Would like to get something like that:

Country   AccountNumber AccountName

Egypt     31007                 GLOBAL EXPENSE

              31009                 GLOBAL EXP2

              33005                 FURNITURE

KENYA   31007                 GLOBAL EXPENSE

             31011                 GLOBAL EXP7

             33006                 FURNITURE BIS

Is this easily possible?

[bidevsugmen]

Hi @Bertrand_fr

Using Matrix visual with the below property should resolve your concern.

Switch off the stepped layout mode.

Hope this helps. Please accept it as a solution if this helps.

Thanks,

Suguna.

[Bertrand_fr · Accepted solution]

Hi Suguna,

Thanks a lot for your help!

Have a good day,

Regards,

Bertrand