Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to add sub-total column based on column headers

jannis005
7 - Meteor

Hello -

 

I am trying to create a column that summarizes information in a row based on the column header. Specifically, I have a schedule that has weeks as column headers and persons as rows with number of scheduled hours per person by week. I want to summarize the budgeted hours for all future weeks, at any given point in time. Is there a convenient way to set this up in a workflow?

 

Thanks!

 

EmployeeTotal Remaining Hours11/511/1211/1911/26
Person 1328888
Person 2328888
1 REPLY 1
Thableaus
17 - Castor
17 - Castor

Hi @jannis005!

Here's what I thought.

 

solutiontranspose.PNG

 

Cheers,

Labels