Calculating column percentage with 2 identifiers

[#1]

Hi everyone, I have a little issue...

I must caluclate the percentage of the column, but considering two identifiers. the formula I'm using at the moment is

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]> [QTA 1 Ordini Cliente])

where <[Descrizione Linea]> is my identifiers. I should get something like that

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]> AND <Other identifier> [QTA 1 Ordini Cliente])

i have attached two pictures to exaplain a little better what I need, so I hope I have been clear enough...

[MK_QSL]

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],Other identifier> [QTA 1 Ordini Cliente])

[alexandros17 · Accepted solution]

Try

Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],[Other identifier]> [QTA 1 Ordini Cliente])

Let me know

[#4]

thank you Alessandro Saccone! I was writing

=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea]>,<[Other identifier]> [QTA 1 Ordini Cliente])

I didn't realize both the identifiers must be within <>!

Many thanks!

[alexandros17]

Di niente Irene ... buon lavoro!