| name | ticket_number | quantity | date |
|---|
| ruth | 96 | 15 | 2013-10-18 |
| alisa | 96 | 20 | 2013-10-18 |
| megan | 54 | 5 | 2013-10-19 |
| ruth | 10 | 2 | 2013-10-19 |
I have done this easily on mysql (Select sum(quantity) from buyer where ticket_number=winner_table.winner_number) but is giving me a hell here because I'm somewhat new.
| date | first_place_ticket | second_place_ticket | third_place_ticket |
|---|
| 2013-10-18 | 96 | 25 | 75 |
| 2013-10-19 | 54 | 54 | 74 |
What Im trying to do:
I need to sum the quantities of winner tickets given a date and store it on a field and/or variable, for example (on the day 18 they were a total of 35 tickets of the number 96, 0 of 25 and 0 of 75.
So I can get something like:
| date | first_winner_quantity | second_winner_quantity | third_winner_quantity |
|---|
| 2013-10-18 | 35 | 0 | 0 |
What I've already tried:
A user of this forum gave me a great solution (THANK YOU AGAIN)....It was a straight table but sadly when a try to implement it to my problem I just sum the quantity of ALL the tickets from that day instead of the winner one only.
I'll attach the customers.csv, winner_tickets.csv and .qvw file with the example I got from here (INLINE) and my failure attempt to emulate that.
I've weeks trying to accomplish this by my own please help me
