I am creating a report from a table that stores data as follows:
ID Name Activity Date Total
1 John Doe Play 2009-06-01 1
2 Jane Doe Run 2009-06-01 2

but i need to get the report in the format of

Name Play Run Total
John Doe 1 0 1
Jane Doe 0 2 2

i am unsure how to generate this result, any help would be great