Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.