1 Reply Latest reply on Oct 28, 2016 3:16 PM by diego.medrano

    Only the first value per Group for Grand Totals

    Max Cz

      Hi guys,

       

      I got a little issue with the grand totals.

      I want to sum up the first value from "Auftragsnummer".

      The prob is that each value is an aggregate measure. (first pic)

      The underneath part consists of 47 and 1, and the first part is just 49.

      In the grand total I want to show the sum of 48+49. So for each "Auftragsnummer" it should count just the first value. But its allways coming up with the wrong total. (second pic)

      Any assistance or ideas will be appreciated

       

       

      Aggregate measure.PNG

      Grand Total.PNG