Challenge #3: Running Averages

[Keppatawn]

Spoiler

[davidnordstrom]

3

[gerda]

Spoiler

Here's the solution!

[JoeChan619]

A nice challenge! Help me recap the knowledge of Multi-Row Formula, Cross Tab, and Transpose Tool.

[yaohuahuang41]

The solution is confusing to me because in the multi-row formulas, the 3 month averages are calculated by grouping by "RM category" but the 3 months averages are not. So that starting record#73 where RM category becomes 100rm, the averages are still reflecting those in 10rm, which is incorrect as we need to calculate the averages by RM category. If the 6 month avg. for 100rm is calculated properly, the result should be 42 instead of 7 [(0+0+0+0+0+0+42)/6]

[AlexMaData]

I didn't quite match the "target" output format but I feel like this column setup is a little more reflective of the enquiry goal...

Spoiler

[yaohuahuang41]

I mean the two multi-formula tools have inconsistent settings-one is grouped by RM category while the other is not.

[lhalliwell]

Spoiler

[MajdiSalie]

Solution:

[sreekanthac]

My solution attached.