return to line

[souadouert]

I use this list of value for a dimension,

=ValueList(dual('Crédits au Particuliers',1),dual('Conquéte',2),dual('PACKS HG',3),dual('PACKS SILVER',4),dual('Epargne',5),dual('Produits stratégiques vol',6),dual('TRPP SYNTH.Hors depots',7))

I want to insert a return to line in an example string: Crédits au Particuliers

[Anil_Babu_Samineni]

I may not sure, What are you expecting. What is the case you are using Dual function here.

=ValueList('Crédits au Particuliers','Conquéte','PACKS HG',3,'PACKS SILVER','Epargne','Produits stratégiques vol','TRPP SYNTH.Hors depots')

[Anonymous]

in an expression you could refer to valuelist() like that:

if(ValueList(dual('Crédits au Particuliers',1),dual('Conquéte',2),dual('PACKS HG',3),dual('PACKS SILVER',4),dual('Epargne',5),dual('Produits stratégiques vol',6),dual('TRPP SYNTH.Hors depots',7))

='Crédits au Particuliers','X')

[annafuksa1]

it depend how you want to use is in chart , list box, text box the formula will be different , but will suggest to create inline table with this values

[souadouert]

inline table anna

[souadouert]

[souadouert]

[Anil_Babu_Samineni]

May be check the "Size to Data" and meantime, You can elapse if you want

[annafuksa1]

so I will create inlene table with fields

LOAD * INLINE [

_%TabName, _%TabNo

Crédits au Particuliers,1

Conquéte,2

...

];

and use function

=FirstSortedValue(_%TabName, _%TabNo, 1)

[annafuksa1]

in this case you need to make the table wider