crosstab

[Kinetic_analytics]

Hello:

How can I transform this table in the Alteryx workflow?

Thanks

[CathyS_Slalom]

Hi @Kinetic_analytics, are you trying to use Alteryx to generate the similar table report using the data on the left? Or you want to read in the data properly from the right summary table from Alteryx?

[Kinetic_analytics]

Yes. I am trying to use Alteryx to generate a similar table report using the data on the left?

[ArtApa · Accepted solution]

Hi @Kinetic_analytics - I am not sure what are the rules to calculate contains, as you put amounts 84, 74 and 24, but not the formulas. I based my workflow on an assumption that if there is a word in the Name it should be summed up like below:

Then the workflow is as follows:

[CathyS_Slalom]

I agree with @ArtApa 's solution.

@Kinetic_analytics And after that you can use table tool from Alteryx to color code the column and generate the reports the way you like it.