Percentage of Total

Reply
Highlighted
Yellow Belt

Percentage of Total

Hi

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

Thanks

Simon

Highlighted
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.

 

Example.PNG

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