Skip to main content
DD-TRF-003 Complex Joins, Exceptions and Transformation Logic Get the data →
DD-TRF-003-Q024 Medium Time series

Value of returns by month

After cleaning, total the Amount in SAR of return lines (negative Quantity) by month. Which month has the largest value returned? Report it as a positive number.
Expected
One row per month: YearMonth, value returned · Line chart
Tables
FactTransformationEvents · columns
  • FactTransformationEvents
  • TransactionDate
  • Quantity
  • Amount

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in