Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Cummunity,
wollte aus einer Tabelle namens ConversionRate, die Artikelnr mit der Menge herausfiltern,
wo die Buchungart auf Verkauf stehen.
Also dachte ich
count(DISTINCT{$ <Buchungsart="Verkauf">}Artikelnummer)
aber irgendwie wird nichts angezeigt und auch keine Werte wieder rausgegeben.
Wie kann man aus einer Tabelle den richtig die Summe aller Verkäufe eines Artikels herausfiltern?
MFG
Eric
yes right i want the summing for each artikelnr.
and yes 8, 6 and 1 are right
i have artikelnumber as a dimension but no graph appears.
maybe i must change data connections between the tables caused by the same name
Try this:
Count(DISTINCT{$<Buchungsart= {'Verkauf'}>} Artikelnummer)
Thx for answer but it doesnt work.
As dimension i have Artikelnummer but the diagramm stays empty.
Are you able to share few lines of sample data?
Artikelnummer Artikelbezeichnung Farbe Warengruppe Menge Buchungsart
0101498550 5 Pockets Denim NOS 550 Jeanswear 1 Retoure
0101498550 5 Pockets Denim NOS 550 Jeanswear 1 Retoure
0101498550 5 Pockets Denim NOS 550 Jeanswear 3 Verkauf
0101498550 5 Pockets Denim NOS 550 Jeanswear 1 Verkauf
0101498550 5 Pockets Denim NOS 550 Jeanswear 1 Verkauf
0101498550 5 Pockets Denim NOS 550 Jeanswear 1 Verkauf
0101498552 5 Pockets Denim NOS 552 Jeanswear 1 Retoure
0101498552 5 Pockets Denim NOS 552 Jeanswear 6 Verkauf
0101498552 5 Pockets Denim NOS 552 Jeanswear 1 Verkauf
0101498552 5 Pockets Denim NOS 552 Jeanswear 1 Verkauf
0101498552 5 Pockets Denim NOS 552 Jeanswear 1 Retoure
0102736503 NOS Suprax lang 503 Herren-Hosen 1 Retoure
0102736503 NOS Suprax lang 503 Herren-Hosen 1 Verkauf
Is the output suppose to be 3? If it is then the expression seems to be working
i get 0 with no article number
and for artikelnr 0101498550 the number of sales total is 6
so u add all verkauf together for on article
maybe i explained it wrong but i want that i get the article number with the amount of sales(verkauf) it has.
so i have a diagramm with the article number and the amount of sales will be the value
May be this:
Sum({$<Buchungsart= {'Verkauf'}>} SalesField)
or
Sum({$<Artikelnummer = p({<Buchungsart = {'Verkauf'}>})>} SalesField)
for what does SalesField stands for when i can ask?
Sorry my bad, I misunderstood your last comment.
so for artikelnr 0101498550, you want to see 6 (3+1+1+1)? Right?
Similarly for 0101498552 = 8 and 0102736503 = 1?
Are we summing Menge here then for each artikelnr ?
May be this as your expression and artikelnr as the dimension
Sum({$<Buchungsart= {'Verkauf'}>} Menge)