Hello All…
Here I am coming with
new challenge. Most of challenges which I have been posting here are not what I
faced. Different people colleagues, friends or blog followers sends these
challenges. I solved for them. This challenge I solved for my friend. Let me
see how you will think about it. It might look simple. Once you start solving
then you will understand complexity in it.
Note:
Please download the Data from below link to solve this challenge. If you use
this data, results should match with images posted.
I just want to show “Average
of Top 10 orders by sum(sales)” for each quarter. See below image.
So, each quarter you should
find top 10 orders by sum(sales). Then you should calculate average of those
top orders.
Please look at
below images for more result examples:
Example 1:
Example 2:
Example 3:
Experiment…
Observe… Learn…