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

Clean amount by category

Join the cleaned export to DimProduct, standardise Category and total Amount in SAR by canonical category. Which category is highest?
Expected
One row per category: name, total · Ranked bar chart
Tables
FactTransformationEvents, DimProduct · columns
  • FactTransformationEvents
  • DimProduct
  • ProductCode
  • Category
  • 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