Create a sub total row in summary report

  • 1
  • 1
  • Question
  • Updated 1 year 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

Gaurav Sharma

  • 5,882 Points 5k badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,882 Points 5k badge 2x thumb
Dan, Can you please help me out?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,664 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.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,882 Points 5k badge 2x thumb
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
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,882 Points 5k badge 2x thumb
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

  • 29,664 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/
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,882 Points 5k badge 2x thumb
Hi Dan,

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

Thanks,
Gaurav
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,882 Points 5k badge 2x thumb
I can provide all the relevant details you want.
Photo of Matthew Neil

Matthew Neil

  • 31,638 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?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,882 Points 5k badge 2x thumb
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.