Alteryx Designer Discussions

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

Dynamic Summarize

PeterAP
8 - Asteroid

Hi, is there a way I can dynamically summarise/total all fields which are numeric? The number of numeric fields is subject to change on subsequent runs

3 REPLIES 3
CarliE
Alteryx
Alteryx

@PeterAP ,

 

Do you have a sample dataset you can share? I would use a combination of the transpose and crosstab tool for this.

 

 

Thanks!

Carli
DataNath
14 - Magnetar

As @CarliE this can be done with a transpose and crosstab. All you need to do beforehand is use a dynamic select to reduce your fields down to numeric only, as so:

DataNath_0-1655299780626.png

 

Input:

 

DataNath_1-1655299797988.png

 

Output:

 

DataNath_2-1655299808240.png

 

Dummy workbook attached.

 

 

 

PeterAP
8 - Asteroid

@CarliE @DataNath Thanks guys, I'd just managed to work this out before I saw the replies and aligns similar to your methods using a combination of the dynamic select, transpose and crosstab tools.

 

This should be useful to anyone else with the same problem.

 

Thanks!

Labels