Creating pivot table like Excel

[Jimmylee4real]

hello all,

I haven trying to create pivot table in alteryx. Can anyone guide me to do so? I have attached the excel sheet with the ideal output I want. I want to output the same table by using Alteryx

with data: 

Ideal pivot table output: 

Thanks

[Stravonski]

This looks like a table, but not a pivot table (summarized figures that are clickable to pull up a new tab with the underlying data).  Is it possible to build a true pivot table in Excel as an output of Alteryx without using a pre-built template?