1 Reply Latest reply on Jan 9, 2015 9:21 AM by Patrick A Van Der Hyde

    How do I aggregate over one measure while disaggregate over another

    Ambuj Agarwal

      Hi All,

       

      I am trying to get a scatter plot going like below. It is scatter plot of sales vs price for one product.

      I had to remove option "Aggregate Measures" to accurately depict the scatter plot being close to trendline.

       

      I need to be able to aggregate the price and Sales to reflect sum of multiple products but not sum it over different dates.

       

      I have :

      1) date

      2) Product ID

      3) Category

      4) Sales

      5) Volume

      6) Average Price is calculated to account for the above

       

      If I select multiple products it just adds the points on the graph for corresponding rows, I want it to keep all dates separate yet aggregate sales on sales for same price points and same date only.

       

      Example.png