How to group column data and use the name of the group as name of the column?

[#1]

Hello everybody, I'm very new to Qlikview and I'm trying to solve one problem for couple day but still stay clueless.

I have a table:

Last_name	Points	Sales_group_name
Smith	10	Alcohol
Lincoln	10	Deserts
Stark	10	Alcohol
Stark	20	Salads
Stark	10	Soup
Smith	30	Salads
Lincoln	10	Soup
Smith	10	Alcohol
Smith	20	Deserts
Lincoln	10	Deserts

In the end of all I need a table that will look like this:

Last_name	Alcohol	Deserts	Soup	Salads	Total points
Smith	20	0	0	30	50
Lincoln	0	20	10	0	30
Stark	10	0	10	20	40

Could you suggest any options for doing this?

I'm downloading data from the DB, first I've tried pivot table but its not working as I need, maybe I need to use some expressions or smth.

Thank you in advance!

[qlikmsg4u]

Create a slider/Calendar object with you date field as Filed

[#3]

Thank you a lot!!

You saved me

[qlikmsg4u]

Glad I'm able to help you ..Please close this thread by selecting Helpful/Correct answerers