Skip to main content
DD-TAX-001-Q020 Medium Time series

The month the coding went wrong

Electronics ("ELC") is standard-rated. For each month, work out the share of ELC Sales invoice NetAmount carrying TaxCode "ZR". In which month does it spike? Give it as yyyymm.
Expected
One month as yyyymm · KPI card
Tables
FactVATTransactions, DimCategory, DimTaxCode · columns
  • FactVATTransactions
  • DimCategory
  • DimTaxCode
  • NetAmount
  • TaxCode
  • CategoryCode
  • DocType
  • PeriodKey

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. Need help? Message us