2 Replies Latest reply on Jun 15, 2013 4:16 PM by cristobal berger

    Data Blending with product of calculated field + Summarized values

    cristobal berger

      Hello to everyone,

       

      I'm currently working with one database and differents levels of aggregation which are exported as separated data sources. The problem is simple yet I can't solve it up to now. On the first data source I've a calculated field called Number of Situations, having a 1-to-n relationship with a second data source given a known "id". So I just want the summarized product between Number of Situations and SUM(Number of Records). As you can see on the attached field "Evidence's Plan" worksheet has what I have until now. As a summary I could like to have the product between the all the values in the matrix and then summarized by "day_of_week" dimension.

       

      Thx