8 Replies Latest reply on Aug 23, 2017 5:20 AM by Lucas Gros

    Double aggregation - CNTD of products with stock above minimum

    Lucas Gros



      It looks like my need needs a double aggregation:

      I analyse product monthly sales.

      Products have an initial stock.

      Products belong to a Style category

      I calculate the "running stock": initial stock - running_sum(sum(qty sold))


      Then, for each category, I want to calculate the monthly CNTD of products that have a stock above minimum.

      That's where the problem is: calculated fields or LODs refuses to do double aggregation. So I cannot see the totals per category:


      Anyone knows how to do that?

      Thank you and have a great day.