How to add subtotals in a report

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

I have a report that displays monthly totals in columns for individuals in the rows. I added the year to the row grouping. Now I have data for 2013 in the top half of the report and 2014 data in the bottom half, with a grand total at the bottom.

How can I add a subtotal for each year, by month? I am not so much interested in a grand total for each monthly column but a subtotal for each month in that year.

I would prefer not to have the months continue to run off the page to the right.

Photo of Mark

Mark

  • 0 Points

Posted 6 years ago

  • 0
  • 1
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
If you have Grouping in your report; and Totals and Averages turned on for your numeric fields; you can display the "summary report" at the bottom of a table-report which shows the Totals and Averages by your Grouping. Not sure if this will help you - but it could.
Photo of Mark

Mark

  • 0 Points
I get totals, grand totals at the end of the report, but I am looking for subtotals. For example, I have a report for a time sheet. Each line has a daily total to the right side and the rows are sorted in date sequence. I want subtotals for each week.
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
Try adding a grouping to your report by the date field and select "week"