10 Replies Latest reply: Jul 21, 2015 8:43 AM by Francesco Norelli RSS

    Set Analysis... Help with this Multiple Condition please!

      I'va a table with these dimensions:



      2)Descrizione Articolo


      I've created two different expressions that calculate sales (vfatturatoAc)  and quantity (qfatturatoAC) for each client (cliente) and for specific category of product (N°Conto):


      Sales: =Only({<[N° Conto]={"0501001*"}>}VFatturatoAC)

      Quantity: =Only({<[N° Conto]={"0501001*"}>}QFatturatoAC)



      My question is how can i calculate how many spare parts ([N° Conto]={"0501001*",0501002*"}) has bought those client who bought at least One of this product ([N° Conto]={"0501001*"}).


      Hope to be enough clear.