I have a report that filters by department. The report displays the data with a MTD and YTD column for each dept which results in multiple columns. I looking for a way to create 2 Totaling columns on the right for All depts, one that sums up all the MTD columns and one that sums up all the YTD columns. Any thoughts?
Date
Votes
3 comments
-
Jet Reports Historic Posts This is a very hard one, but one you will encounter occasionaly.
I tried several tricks, but the easiest one every time was trying to recreate a query (NL("Sum")) that could fetch the totals. -
Jet Reports Historic Posts Hi Kathy,
Maybe you can use the SUMIF function to solve this.
Based on your description I created a small Excel sheet with data (no Jet functioons) to show you how I would solve this.
Please let me know if this is what you were looking for and were able to finish your report. -
Jet Reports Historic Posts Thanks for adding that Hans, but I always had little or no success with the SUMIF, I'll look into it again when I need it.
Please sign in to leave a comment.