Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
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.
May be try this
SUM(TOTAL <[Calendar.Monat]> Aggr(count({<[Berechnung.Menge_IST]= {">0"}> } distinct [Berechnung.SalesLine.LINENUM]), [%SalesID] ))/SUM(TOTAL <[Calendar.Monat]> Aggr( Count(Distinct [Berechnung.SalesLine.LINENUM]), [%SalesID] ))
May be try this
SUM(TOTAL <[Calendar.Monat]> Aggr(count({<[Berechnung.Menge_IST]= {">0"}> } distinct [Berechnung.SalesLine.LINENUM]), [%SalesID] ))/SUM(TOTAL <[Calendar.Monat]> Aggr( Count(Distinct [Berechnung.SalesLine.LINENUM]), [%SalesID] ))