hey guys....probably a very simple problem but I've been stuck on this for quite a while.
I want to build a line chart with date as dimension and the value my orders as result (expression)
I have three tables:
Customer (Customer ID, Name, ....), Product(Product ID, Name, Price,...) and Sales (CustomerID, ProductID, Date,...)
On the "Dimension" tab I selected the date and on the Expression tab I entered the following statement
The Problem is that the values are not added correctly.
Any ideas please?