When I follow the training materials and the training videos provided, I have to create the REVENUE metric. So far so good, but when I enter the FILTER part in the formula, it does not accept it.
My formula: Transactions.Amount[FILTER: Transactions.Account.Category = "Revenues"][By: Transactions.Account, Transactions.Country, Transactions.Month, Transactions.Team]
Error message: Error: Expressions are incompatible and cannot all be converted to Dimension ('Data Hub - JV'::'Account Category')
Can someone support me to guide me what I do wrong?
Best answer by helen.vuletinView original