1 Reply Latest reply on Jan 9, 2015 9:21 AM by Patrick 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.