Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'va a table with these dimensions:
1)Cliente
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.
Thanx.
Francesco.
Table1: This is the chart with the correct data
Table 2: This happen when i want to see how many spare parts has bought those client that has at least 1 Quantity
As you can see comare some clients that has bought spare parts but has never bought 0501001.
thanx