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
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello -
From what you describe, you want to perform what is referred to as a "sort by sum".
There is a fantastic conversation about how to do that on this Community Site.
Take a look here –> http://community.jetreports.com/viewtopic.php?f=23&t=2109&p=10489
I hope that helps.
Please sign in to leave a comment.