Challenge No. 180: List the total sales, maximum change in sales month on month basis (absolute value) and From and To months when this maximum change occurred.
Solved using: Python.
Table.AddColumn
Adds a new column to a table with computed values in Power Query.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.
Family Relationship Tree View
Challenge No. 175: List the Names along with the Names of next generation and relationship between generations.
Solved using: Python.
Monthly Sales Split Calendar Days
Challenge No. 174: For all employees, insert the rows for each month and divide the Sales amount over these months as per number of calendars days in the month.
Solved using: R.
Pivot Table by Agent
Challenge No. 173: Pivot the given table as shown.
Solved using: Python.
Calculate Agent Commission Totals
Challenge No. 172: Find the total commission paid to each agent along with a Grand Total row.
Solved using: R.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
Min and Max Dates by Group
Challenge No. 398: Generate the min and max dates for different year and month combinations.
Solved using: Python in Excel.