0

Sorting

Hi, Sorry for my English it isn't very good:

I wan't to select a hit of the color of my product i have sell and present him with the best in first.

I set a table with 3 column:

- The firt an NL line who list the color : =NL("Lignes";"Statistiques ventes";"Décor 1";"Groupe";"230|120|110|100";"Teinte RH";"AUTRES TEINTES";"Type document";"Facture";"Date";Options!$E$4)
- The second who i have the problem (i explain this below)
-The third the sell quantity of the color whith an NL sum: =NL("Somme";"Statistiques ventes";"Quantité";"Type document";"Facture";"Groupe";"120|230";"Date";Options!$E$4;"Teinte RH";"AUTRES TEINTES";"Décor 1";$C7)

I wan't to sort the list with the color xho are most sell in first so in my second column is my sort column, i tri to utilise the apostrophe function but that not work: ="-=NL(""Somme"";""Statistiques ventes"";""Quantité"";""Décor 1"";NF(;""Décor 1"");""Groupe"";""120|230|110|100"";""Type document"";""Facture"";""date"";Options!$E$4;""Teinte RH"";""AUTRES TEINTES"")"

Can you help me?

Thank you

1 comment

Please sign in to leave a comment.