Can I use more than 1 sub-total function on my jet report?
For examples I have linked 2x tables. Firstly I want to sort and sub-total on GL account. Secondly I want to sort and subtotal on global dimension 1 within the data provided on the intital sort.
Can anyone help?
I can now add 2x subtotals on my report. The first subtotal is working correctly, but I do not know how to tell jet report to group by a certain field.
Can anyone help on grouping and subtotaling?
Tracy, UK.
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Okay I promised a worksheet
I tested this on Company with 13 different Global ones and it appeared to work - just took forever :roll: -
Jet Reports Historic Posts Have you tried
Row 1 1st filtering the GLEntry table by account (No sense reporting unused accounts in my opinion)
Row2 rows=4 by selecting accounts from GLACCOUNT using the +NO. and the filter cell
Row3 Create filter on GLEntry for GD1 using that row2 account
Row4 NP ("Join",above cell,"|")
Row5 NL(ROWS=3 ,NP("Split",Np Cell","|") gives you GD1 per account
Row6 Now Create rows from GLentry selecting on account and GD1 from above
Row7 Subtotal on each new GD1 Row
Row 9 Subtotal on account
That gives you account and GD1 grouping plus subtotals Bit cumbersome and you may need to play with rows value but should get you what you're looking for -
Jet Reports Historic Posts LOL There are some issues with solution I posted so I am currently creating a sheet which I'll upload when done . I've been using a lot of the join and split in reports recently since we went to 3rd dimension in one company but I suspect it's close to impossible to get the formula as I put in response to replicate correctly . Sigh and today isn't even Monday
-
Jet Reports Historic Posts Thank you.
I can now complete multiple sub-totals.
Kind regards
Tracy
Please sign in to leave a comment.