3 Replies Latest reply: Mar 7, 2014 4:03 AM by Marco Wedel RSS

    Display Multiple Datedimensions in on Diagramm

      Hi everyone,

       

      I've got a dataset where each row has 2 date dimensions (order date and consumption date). I'd like to display the sum on monthly basis for both dimensions in 1 diagram:

       

      monthordersconsumptions
      Jan 20103454
      Feb 20104530
      Mar 20103454

       

      The original dataset is way too big to calculate it via an external calendar table and if-statements in the calculations. Does anyone deal with a similar problem and has got a solution for implementing such a date dimension with scripting?

       

      Thanks!

       

      Best regards,

      Benedikt