Create a sub total row in summary report

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
Hi Team,

I am trying to add a sub-total row at each level of SOW .

Thanks,
Gaurav
Photo of Gaurav Sharma, Certified Builder and Expert

Posted 3 years ago

  • 1
  • 1
Dan, Can you please help me out?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
Ya gotta put a little more effort into forming your question. I have no idea what  fields, tables or other constraints you have. If you can't form the summary report using native features you have to use script and that script will need details.
I have a table called time cards in which i have created a summary report in which summarized the billing hours of associates based on client, SOW etc.

Table Name:  Time Cards

I have attached two more snippets of report columns and other related information.

Apart from that, you need more info?

Please let me know.

Regards,
Gaurav
Hi Dan,

Did you get a chance to look into this?

Regards,
Gaurav
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
Your inquiry is more suited to a small consulting project rather than a forum answer as there are a series of questions to ask and details to acquire (such as dbid, fids, etc) that would be unique to your application. Feel free to contact me off-world using the information in my profile if you would like to pursue an individualized solution:

https://quickbase-community.intuit.com/users/513/
Hi Dan,

If you can guide me.. i can do with your help.

Thanks,
Gaurav
I can provide all the relevant details you want.
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Gaurav, have you tried making a regular table report, but set the grouping to basically add subtotal.

Beyond that you might need to contract a professional to really dive into what you need and make it happen.
Photo of Karan Bhavsar

Karan Bhavsar

  • 178 Points 100 badge 2x thumb
Gaurav, were you able to implement a sub-total row?
Nope. But, you can take a look here.

https://community.quickbase.com/quickbase/topics/hello-i-am-looking-to-create-a-two-level-summary-re...

Dan had given a solution there and if you will be able to implement the same.then it is only possible to achieve this.