How do you create a column in ETL that sums an entire column?
I am trying to create a card that gives percentage of total, from looking at other posts the way to do it would be to create a column in ETL which gives the Grand Total of an entire column, example attached, then create a beast mode in a card.
But I can't figure out how to create a Total column.
The only way I have found for creating a total column is to split the data as below add a single constant to every row you want to include in your total. Then group by the constant and create a new sum column then rejoin on the constant. You can then eliminate the constants and there you go.