Dynamic Summarize

Question

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 Answer

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

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 Answer

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