I am trying to sort data in ascending order depending on how much source no. bought (highest to lowest).
Can some one help me…
9 comments
-
Jet Reports Historic Posts Sorting in Jet quite simple. You should find all the info under 'Help' option from the Jet menu in Excel.
Below are a couple of examples that should give you the idea. Note + and - characters. Basically just add + or - to your fieldfilter.
nl("Rows","Item ledger Entry",,"-Quantity.","*") - highest to lowest (decending order)
nl("Rows","Item ledger Entry",,"+Quantity","*") - lowest to highest (ascending order) -
Jet Reports Historic Posts Thanks
But it is not sorting the data according to sum
I need to arrange the data according to the sum(Quantity) for the source no. -
Jet Reports Historic Posts Ah, I see. You can probably get what you need from this post here:
http://community.jetreports.com/viewtopic.php?f=7&t=310&st=0&sk=t&sd=a
cheers -
Jet Reports Historic Posts I tried that but it is still not sorting the data
NL("rows","32","Source No.","Posting Date",C3,"Source No.","<>' '","+=-nl(""Sum"",""32"",""Quantity"",""Source no."",nf(,""Source No.""),""Posting Date"",C3)","*","Item Tracking","Serial No.")
I need the data to be sorted according to sum of quantity -
Jet Reports Historic Posts In the section where you have "+=-nl(""Sum""
Try "+=nl(""Sum"" or "-=nl(""Sum"" i.e., the + or - is before the = not after.
Give that a try. -
Jet Reports Historic Posts I tried that.
It is still not sorting the data… -
Jet Reports Historic Posts This was also an issue in the post I referred you to. Have a look at what was done on the second page of that post regarding the reference to the cell containing the Posting Date.
I'm not sure if that is causing your issues or not, but worth a try.
""Posting Date"",$E$7
to
""Posting Date"","""&$E$7&""" -
Jet Reports Historic Posts No luck
-
Jet Reports Historic Posts You might have to contact support to get this resolved. Based on the formulas you have posted already, I don't have data in our system to troubleshoot the report for you.
A few points I noted with your formula that you posted:"Source No.","<>' '"
if you're trying to say not equal to blank, try "<>@@"