Total Column in a different column

gotex · December 2020

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 · December 2020

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 · December 2020

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 · December 2020

It worked perfectly! Thanks!

Total Column in a different column

Best Answer

Answers

Categories