1 Reply Latest reply: Jul 18, 2018 12:07 PM by Sunny Talwar RSS

    count- every row should have the same result (Total)

    Martina Jakovcic



      I would like, to have in every row the result from the count. Like in column DS=7.





      I try with SUM(TOTAL Aggr(count({<[Berechnung.Menge_IST]= {">0"}> } distinct  [Berechnung.SalesLine.LINENUM]), [%SalesID] ))/SUM(TOTAL Aggr( Count(Distinct [Berechnung.SalesLine.LINENUM]), [%SalesID] ))


      but the problem is, i have the same result i every column. For every Kanal should be other result.



      When i select specfic Month Feb. and the "Kanal" then is the result true:



      How i can became in overal the right total?


      Thank for you help.