how to add text/remarks

DarrenS
Occasional Contributor

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 ugly. Is there a way to choose left,right or centre alignment? I can't seem to find the option. 

Thanks a lot.  

 

 

 

 

DarrenS_1-1620383366108.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHeathcote
Community Boss

Re: how to add text/remarks

@DarrenS 

How many L3 sit under Asia? 

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

ChrisHeathcote_0-1620635699830.png

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.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

5 REPLIES 5
ChrisHeathcote
Community Boss

Re: how to add text/remarks

@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.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
DarrenS
Occasional Contributor

Re: how to add text/remarks

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.

 

 

DarrenS_0-1620615040663.png

 

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? 

DarrenS_1-1620615638156.png

 

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

ChrisHeathcote
Community Boss

Re: how to add text/remarks

@DarrenS 

How many L3 sit under Asia? 

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

ChrisHeathcote_0-1620635699830.png

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.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

DarrenS
Occasional Contributor

Re: how to add text/remarks

Hi @ChrisHeathcote 

 

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. 

 

DarrenS_0-1620639118755.png

 

ChrisHeathcote
Community Boss

Re: how to add text/remarks

@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.

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA