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

Anonymous — Wed, 22 Dec 2021 15:42:54 GMT

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.

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

sunny_talwar — Wed, 18 Jul 2018 16:07:32 GMT

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] ))

topic count- every row should have the same result (Total) in App Development

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

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