Dynamic Summarize

[PeterAP]

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

[CarliE · Accepted solution]

@PeterAP ,

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

Thanks!

[DataNath · Accepted solution]

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:

Input:

Output:

Dummy workbook attached.

[PeterAP · Accepted solution]

@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!