/ dt / PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount / TerminateReason

TerminateReason

[ROOT]  dt  PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount  PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine 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 DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount'.

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

Generated 2024-06-03 04:46:18.314 UTC