Percentage of Total

Yellow Belt

Percentage of Total


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.

Any help would be appreciated



Yellow Belt

Re: Percentage of Total

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.



MCB Majordomo at Tower Products
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.