Hi @ all, (and take care…jet-newbie approaching ;-) )
I have successfully cretaed a neat liitle table with Jet Essential 2013 table builder on FA ledger entries. Everything is good, the only tweak o this table I'm not able to do so far is to generate a subtotal of AMOUNT after each FA Number. I get the complete sum of all my Fixed Assets - no problem, but I'd like to have a subtotal on each asset seperately.
Every information on this is higly appreciated.
Thnx in advance!!!!
Greez,
Steve
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Steve,
This sounds like the sort of thing you would want to use an Excel pivot table for. Just create a pivot table based on the NL(Table) being generated by Jet. Then you can group the pivot table by the FA Number and get subtotals easily. Does that help?
Regards,
Hughes
Please sign in to leave a comment.