Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Add row After one group with Running Total

dinesha
6 - Meteoroid

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 

 

 

dinesha_0-1655914412526.png

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

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
17 - Castor

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.

 

DataNath_0-1655915305128.png

 

dinesha
6 - Meteoroid

THANKS IT WILL WORK FOR ME AND I WILL UPDATE YOU 

Labels