In the Pivot Table visualization type, you create the Pivot options in the same manner as in Excel by selecting the grouping action and then playing with the columns/rows.

In case you don't want to provide the end user with flexibility of changing pivot values, you can check the Hide Pivot Controls checkbox: