How to Add row After one group with Running Total

[dinesha]

I have a output table where i have two group 

1. Undergraduate Course

2. Post Graduate Course

under both the coursed we have courses with fixed seats

now i want after  a group like undergraduate Course i want a row specify total number to seats in undergraduate course

like Total :1080 

and same for post graduate 

let me know how i can do this 

[IraWatt]

Hey @dinesha,

Would you be able to provide any sample data with your question and a desired output? Are you looking for a Running Total or a overall total for the two groups?

Thanks,

Ira

[DataNath · Accepted solution]

How does something like this look? Depending on positioning you can change the Union configuration - I just left it as a separate column to stand out as the total rather than a number of seats. Can also rename/rearrange the fields in the Select as you wish.

[dinesha]

THANKS IT WILL WORK FOR ME AND I WILL UPDATE YOU