0 Replies Latest reply on Sep 23, 2013 10:10 AM by Siddharth Surana

    Grouping by [SUM(Max(Amount))]

    Siddharth Surana

      Hey Guys


      I have a hierarchy that I use to collapse / expand the data and the numbers. It is such as:


      1. Order

      2. Order Line - 1 Order has many Order Lines

      3. Day - 1 Order Line may / may not have many days.

      4. Amount


      My data source is not broken down by the day level and hence, when there is more than 1 day for a Order Line, the number is repeated and the data is wrong.


      So I wanted to know if there was a way to first just take the Maximum Order amount from the number of days and then sum those maximum amounts to the Order level ?


      Is there a way to use one aggregation (MAX) when the hierarchy is at the Order Line level and Use (Sum(MAX)) when the aggregation (drill down) is rolled up to the Order level?