Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Try
Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],[Other identifier]> [QTA 1 Ordini Cliente])
Let me know
=Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],Other identifier> [QTA 1 Ordini Cliente])
Try
Sum ([QTA 1 Ordini Cliente])/Sum (TOTAL <[Descrizione Linea],[Other identifier]> [QTA 1 Ordini Cliente])
Let me know
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!
Di niente Irene ... buon lavoro!