/ dt / FactResellerSale / PIVOT%20OrderDate.YearMonth()%20BY%20DimCurrency.AlternateKey%20SUM%20SalesAmount / SELECT%20*.TMB()%20AS%20* / ORDER%20BY%20OrderDate.YearMonth()Id%20DESC / TITLE Reseller sales per year and month
TITLE Reseller sales per year and month
[ROOT] dt FactResellerSale PIVOT%20OrderDate.YearMonth()%20BY%20DimCurrency.AlternateKey%20SUM%20SalesAmount SELECT%20*.TMB()%20AS%20* ORDER%20BY%20OrderDate.YearMonth()Id%20DESC TITLE Reseller sales per year and month
ERROR:
At hierarhical level dt/FactResellerSale, key 'PIVOT%20OrderDate.YearMonth()%20BY%20DimCurrency.AlternateKey%20SUM%20SalesAmount' not found
In case you attempted to supply a QueryExpression, this error message may be of help:
Start of query expression 'PIVOT%20ORDERDATE.YEARMONTH()%20BY%20DIMCURRENCY.ALTERNATEKEY%20SUM%20SALESAMOUNT' 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
Use this link to see available keys at this level:
Generated 2024-05-06 02:55:57.389 UTC