2 Replies Latest reply: Feb 9, 2015 5:55 AM by Tresesco B RSS

    Not aggregation by dimension

    Андрей Шепель

      Good day!

      Is  any way to solve such task.

       

      I have pivot table with dimension Sales Point and YearMonth.

       

       

      My expr: sum(Volume)/count(Distinct [Sales Point])

      I need: sum(Volume) to aggregate by YearMonth,

                 count(Distinct [Sales Point]) not aggregate by YearMonth

      Thanks.