2 Replies Latest reply: Feb 6, 2014 10:09 AM by Anna Perini RSS

    3 calendars in 1 graph

    Anna Perini

      I've a report with 3 calendars:

      Order_date

      Delivery_date

      Invoice_date

       

      and I've to create a bar graph where a sum for each date:

      - for how many goods I've received orders,

      - how many goods i've delivered,

      - for how many good i've billed.

       

      I've tried to build set analysis using in x axis Order_date and with this syntax:

      sum(Order_date={'$(Delivery_date)'}>}product_code)

      sum(Order_date={'$(Invoice_date)'}>}product_code)

      And it doesn't work. How can I solve my problem? Tks