I'm trying to make something like this in Tableau so that the 3rd column shows the sum of all A's (i.e. 1 + 2 + 3 + 4 =10) and the sum of B's etc.
I've read some posts about using WINDOW_SUM() and TOTAL() calculated fields but I haven't been able to succeed on this front. Any help would be greatly appreciated!
You can use LOD to accomplish this.
Overview: Level of Detail Expressions
Below two calculations brinig same results. Both use LOD.
[By Category 1]
{exclude [Value] : sum([Value (copy)])}
[By Category 2]
{fixed [Category] : sum([Value (copy)])}
Thanks,
Shin
9.0 attached.