Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I am trying to find a solution for this issue:
I just have this excel with this information:
MEMBER | REG DATE | TERM DATE | CUST TYPE | ENTRANCE FEE | DAYLY FEE |
LUIS | 01/06/2013 | 12/06/2013 | 1 | 100 | 50 |
PABLO | 05/06/2013 | 15/06/2013 | 1 | 100 | 50 |
LUCAS | 08/05/2013 | 1 | 100 | 50 | |
MARIA | 10/06/2013 | 2 | 200 | 100 |
Where:
Member > Guest
Reg Date > Registration Date when the guest signs in.
Ter Date > Termination Date when the guest signs out.
Entrance Fee and dayly Fee.
I want to track which are my incomes every day from the first date of Reg Date till today (when today is the day I reload the document).
Something like this:
MEMBER | 01/06/2013 | 02/06/2013 | 03/06/2013 | 04/06/2013 | 05/06/2013 | 06/06/2013 | 07/06/2013 | 08/06/2013 | 09/06/2013 | 10/06/2013 | 11/06/2013 | 12/06/2013 | 13/06/2013 | 14/06/2013 | 15/06/2013 | 16/06/2013 | 17/06/2013 | 18/06/2013 |
LUIS | 150 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 0 | 0 | 0 | 0 | 0 | 0 |
PABLO | 0 | 0 | 0 | 0 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 0 | 0 | 0 |
LUCAS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
MARIA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
If I reload the document the 05th of JulyI have to obtain the rest of the days automatically, so I can track my incomes by just using the first imput excel.
Is there anyway I can achieve this?
Thanks a lot in advance.
PD. Excel attached.
Regards
Any idea anybody?
Regards
See attached qvw.
That was great!
Thanks a lot...
That was great!
Thanks a lot...