Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
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
inline table anna
May be check the "Size to Data" and meantime, You can elapse if you want
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)
in this case you need to make the table wider