Total Column in a different column

gotex

Good Morning

 

I have a column let's say (look below)  Is there a way to create another column with the total sum of that column? So it reads a new column that says total and it should be the same number? Thanks!

 

category                              category               total 

A                1                        A             1              6

A                0                        A              0             6

A                2                        A              2             6

A                3                        A             3              6

A                0                        A             0               6

B                0                        B             0              2

B                2                        B             2              2

TOTAL 8

 

 

 

jaeW_at_Onyx

sounds like you're trying to do a category subtotal.

 

you can implement that with a windowed function

sum(sum(amount)) over (partition by category)

 

you need to have the feature switch enabled.  talk to your csm.

 

If you've never worked with them before they can be super powerful but also have some pretty stringent caveats.

https://www.youtube.com/watch?v=eifSYZIcPzg&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=5&t=466s

jaeW_at_Onyx

sounds like you're trying to do a category subtotal.

 

you can implement that with a windowed function

sum(sum(amount)) over (partition by category)

 

you need to have the feature switch enabled.  talk to your csm.

 

If you've never worked with them before they can be super powerful but also have some pretty stringent caveats.

https://www.youtube.com/watch?v=eifSYZIcPzg&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=5&t=466s

gotex

It worked perfectly! Thanks!