/ dt / PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount / TerminateReason

TerminateReason

[ROOT]  dt  PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount  PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount   

ERROR:

Query expression

TerminateReason

failed to parse with the following error response:

Start of query expression 'TERMINATEREASON' not recognized. Must start with one of

----, AGGREGATE, ALL, CACHE, COMMENT, DATASTORAGE, HINT, LIMIT, LOG, ORDER (as in (OrderBy), PIVOT, REL, SELECT, SELFCREATE, SHUFFLE, SKIP, STRICT, TAKE, THEN (as in (ThenBy), TITLE, WHERE

Last query expression to successfully parse was 'PIVOT OrderDate.YearMonth() BY DimCurrency.AlternateKey SUM SalesAmount'.

(NOTE. After the first valid QueryExpression, all following items in the request must also be valid query expressions)

Generated 2026-07-22 12:18:50.848 UTC