Count

[#1]

I have done this kind of statistics several time, but this time I don't understand what I'm doing wrong. I would like to count the number of suppliers so I'm using the formula =count([Ragione Sociale Fornitore]) that I've always used. The point is that in case the supplier is repeated, it is counted only once, while I want to be counted twice.

What I'm doing wrong???

[#2]

ho provato a riattacarlo...prova un po' di nuovo...

[richard]

You are using a pivottable. The pivot on column "Codie Do..." is represented once. Try using a straight table.

[alexandros17]

Purtroppo non riesco ancora, fai così comunque:

carica in una tabella piatta i dati e verifica quante ragioni sociali hai, se sono 15 allora il risultato è corretto, altrimenti count(num_doc) dovrebbe funzionare, che risultato i da?

[#5]

addirittura 59...

[#6]

I must use a pivot chart though...cannot change it...

[alexandros17]

Prova così:

Count(Aggr(num_doc, codice_doc))

Fammi sapere ...

[#8]

niente...no dà alcun risultato...

[alexandros17]

Devi aggregare (prova altre combinazioni) il conteggio del numero di documenti per la chiave della tabella in cui si trovano ...

[martynlloyd]

My solution to this type of problem is to add a field in the script:

Suppliers:

LOAD

1 as CountSupplier

...

I can then use this in the expression Sum(CountSupplier) and the pivot summation works for all levels.

Regards.

[#11]

I might think that this expression could it be the solutions

=AGGR(NODISTINCT SUM({[Ragione Sociale Fornitore]}),<[Numero Documento],[Data Documento]>)

but there is an errore as a fact that I'm not getting any result...does anyone know where and which is the mistake??