Hello, I'm new in QV and I need some help for a document that I'm creating.
This is
- I have two tables, one with customer data (and includes the period -MONTH/YEAR, called PERIODO_ALTA) and another with the dates on which the payment is recorded and that incudes the same period (again MONTH / YEAR and it's called PERIODO_PRIMER_PAGO ). Tables are joined by the field ID_CONTACTO
The user will filter PERIODO_ALTA an then I need pivot table like this
PERIODO_ALTA #Customers #Payments
Jan-2013 625 125
feb-2013 515 325
......
That is, the column #Customers should show the number of clients who contract in this period (month/year) and the column #Paymentsthe number of payments that occur in this period regardless of when they were hired. What you should do is somehow match the expression PERIODO_ALTA = PERIODO_PRIMER_PAGO but I do not know how to do it
Thank you!
