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

Regions driving the year-on-year change

After cleaning, bridge the clean Amount in SAR from the prior year to the latest year by canonical region. Which region contributed most, and what is the net change? Reconcile the bridge to the totals.
Expected
Region, prior, latest, change; reconciliation total · Variance bridge
Tables
FactTransformationEvents, DimCustomerSCD · columns
  • FactTransformationEvents
  • DimCustomerSCD
  • CustomerCode
  • Region
  • TransactionDate
  • 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