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

Limit

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

ERROR:

Query expression

Limit

failed to parse with the following error response:

errorResponses:
Not two words like 'LIMIT {limit}' but 1 words.
Syntax:
Syntax: LIMIT {limit} like 'LIMIT 42'

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 20:59:02.947 UTC