Hi,
I was wondering if it is possible to sort a grouped report based on the subtotals that were calculated in the report using the Excel =SUBTOTAL() function. I know that it is possible to sort by sum, is there anything similar that can be done for the subtotals function? Any help is appreciated.
Thank you!
-Artem
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Artem,
You can't necessarily sort by the subtotals but you could sort by an NL(Sum) formula which you could probably write to calculate what it is you're subtotalling. I wrote a little bit about how you create a sort by sum formula in this thread:
http://community.jetreports.com/viewtopic.php?f=23&t=2109
Take a look and if you can't figure out how to do it, post some more specifics about your replicator function and what it is you're subtotalling that you want to sort by.
Regards,
Hughes -
Jet Reports Historic Posts Hello Hughes,
Thank you for answering. I took a look at the topic that you referred me to, but I think it is different from what I am trying to do. I am using a database that is different from Navision, however I don't think it makes much difference. In my report I am computing material cost per asset (based on the parts used). First, I am using NL(Rows) function to create a list of active assets that used parts within the specified period of time. In the row below I use another NL(Rows) to create a datadump list of part stock numbers used for each asset. Since the database can only provide me with the quantity of particular parts per asset and their respective price per unit I have to calculate the material cost for each part by multiplying the quantity of parts used by their price (material price per part = qty of parts * price per part). Then I use a =SUBTOTAL() function to add all individually caluclated material prices, which gives me the total price per asset. Ideally I want the report to sort the asset numbers based on the material cost subtotals that are calculated for each asset. I attached the picture with my table and the replicator functions that I used, I am looking for a way to sort asset numbers based on the subtotal value that is located in cell J10. I would appreciate any suggestions, since currently I know no other way of sorting this report other than manually.
Best,
-Artem
Please sign in to leave a comment.