1 Reply Latest reply: Aug 10, 2010 11:32 AM by Martina Brenner RSS

    Building a line chart

    max-soa12

      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?