4 Replies Latest reply: Jun 10, 2014 6:38 AM by Alessandro Saccone RSS

    Calculating column percentage with 2 identifiers

      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...