Challenge No. 654: Work out the % Revenue share of each year within a group where % = Revenue / Sum of Revenue of a Group.
Solved using: Python in Excel.
Custom Grouping
Challenges related to custom data grouping.
Running Total With Reset
Challenge No. 649: Calculate the running total for each group.
Solved using: Python.
Sum Between Plus Groups
Challenge No. 640: Treat the data between two pluses as one group.
Solved using: R.
Find Immediate Previous Caller
Challenge No. 630: For each date group, populate the immediate last caller.
Solved using: Python in Excel.
Sequential Group Numbering Logic
Challenge No. 596: This challenge is contributed by Ankur Sharma
Populate 1, 2, 3.
Solved using: Python.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Number Groups for Letter A
Challenge No. 581: Populate 1 in first group of As and for every succeeding group of As, add 1 to the count.
Solved using: Python.
Split Periods For The Project
Challenge No. 74: Create Weekly Date Groups and Sum
A Week runs from Monday to Sunday
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Create Weekly Group
Challenge No. 72: Create Weekly Date Groups and Sum
A Week runs from Monday to Sunday
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Check Lexically Sorted Dates
Challenge No. 507: List the dates which are lexically sorted.
Solved using: Python.