how to add text/remarks

Hi,

I would like to add remarks/text as shown in the pic below. I've tried to do it via formula but it doesn't roll up to the highest hierarchy level. For example, if i choose "Asia" , the text doesn't show. But if you choose a lower hierarchy level, it's able to show the intended text. Furthermore, the text alignment is ****. Is there a way to choose left,right or centre alignment? I can't seem to find the option.

Thanks a lot.

Accepted answers

ChrisAHeathcote

@DarrenS

How many L3 sit under Asia?

It is possible to reference child text entries at the parent level but there are limited options.

Notice that for TEXT the options relevant to you would be FIRST NON BLANK or LAST NON BLANK.

These options will summaries up the hierarchy showing the text occupy the corresponding cell.

However, this will continue up the hierarchy through L1.

Using summary methods may not be the best way to show the cell contents at higher levels but if you are determined to show the data at L2 and above in the same module it is your only option.

There is no current workaround for text alignment in a cell.

All comments

ChrisAHeathcote

@DarrenS

How do you expect the text to display as you travel up the hierarchy?

From your screenshot you have Asia selected as a page.

Which of the Asia child items would you expect to see displayed at the parent level?

With regard to alignment, there is no option to change this from the default.

DarrenS

Hi Chris,

I've done up the sample of the text that i would like to display for your reference. Basically, the same remarks is applicable to different hierarchy level.

When i select on the parent which is "Asia", the text doesn't follow through. I would like it to show the same remarks as the above. Is there a way to do this?

Is there a work around regards to the default alignment of the text?

ChrisAHeathcote

@DarrenS

How many L3 sit under Asia?

It is possible to reference child text entries at the parent level but there are limited options.

Notice that for TEXT the options relevant to you would be FIRST NON BLANK or LAST NON BLANK.

These options will summaries up the hierarchy showing the text occupy the corresponding cell.

However, this will continue up the hierarchy through L1.

Using summary methods may not be the best way to show the cell contents at higher levels but if you are determined to show the data at L2 and above in the same module it is your only option.

There is no current workaround for text alignment in a cell.

DarrenS

Hi @ChrisAHeathcote

I have another question.

I have added a page selector for "Account type" as I would like to filter the list of accts by account type

But it doesn't sync with the the list. Did I miss out on any additional steps?

Thanks.

ChrisAHeathcote

@DarrenS

A page selector or dimension is not a filter.

Can you raise this as another query and I will provide a more detailed response.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…