Total Column in a different column

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

Find more posts tagged with

Accepted answers

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

All comments