Hi all,
1. I run a monthly query with a set of tools and output a single average value per Business Area with the SUMMARIZE tool.
2. In the next month, I copy the existing workflow, change the source of input file and bring the result from last month and this months together with the UNION tool.
My output shows the months and the average value per month and Business area.
3. For all upcoming months I repeat step 2.
The output of my results will be shown in Excel under the results from the previous months.
Now my question: is there any chance to get the output into a table format?
My results:
Jan Business Area 1 24
Jan Business Area 1 19
Jan Business Area 1 27
Jan Business Area 2 17
Jan Business Area 2 11
Jan Business Area 2 14
I would like to see:
Jan Feb Mar
Business Area 1 24 19 27
Business Area 2 17 11 14
Any ideas?
Solved! Go to Solution.
Have you tried the CROSSTAB tool?
Groupby [business area]
header - month
data - value
Calculate
sum
that might solve your need.