Multiple header (in different line) for same column

AdamSayyad

Expected output where each column has two header i.e account (in 1st line- green) and Description (in 2nd line - yellow)

To achieve desire, result in Anaplan I have created two separate list account and description.

It is giving me the expected result, but this module will be referred by multiple models. I will have to use these two lists in multiple modules. It will increase the size of model since two list are used.

I tried using one list with code as account but not able to get expected view.

Is there any other way anyone can suggest.

luke_e

A few questions,

• Is it one to one.. as in, there can only ever be one 'description' to the account?
• Is this fixed and doesn't change by version?

If yes to both the above, you can likely use a property against the list.

Here's an example, green is with the additional property; yellow is what you'd see by default.

Output

Setup

To do this, create a new property against the list which represents the description (I've called mine display name 2),

Then, when running the export, you'll need to add this display name 2 to the label runtime,

Once you hit export, it'll append the additional name to the list (whether it be row or column, depending on where you've put it in your pivot).

If you're running this on an adhoc basis, you'll need to add this every time. Or you can create an export action which will always include it. Either way works.

Hope the above helps.