/ dt / PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount / Queries

Queries

[ROOT]  dt  PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount  PIVOT OrderDate.Year() BY DimReseller.ProductLine SUM SalesAmount   

ERROR:

Query expression

Queries

failed to parse with the following error response:

Start of query expression 'QUERIES' 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.Year() 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-01 22:47:03.950 UTC