Building a line chart

[#1]

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

sum( [Price])

The Problem is that the values are not added correctly.

Any ideas please?

[brenner_martina · Accepted solution]

Hi,

I think sum(Price) is wrong, because your Table Product has no connection to the date, would be better, you enter the expression: Sum(Quantity*Price), if Quantity is a field from Table Sales.