Pivot Table with sub-total

[kauser]

Hello,

how can i get this pivot table (shown below) 

Input Data- 

Company	Name	$$
45	12	232
45	23	464
45	12	928
45	23	1856
50	45	3712
50	67	7424
50	45	14848
50	67	29696
50	80	59392
65	70	118784
65	80	237568
65	70	475136
65	80	950272
65	70	1900544
100	90	3801088
100	20	7602176
100	90	15204352

Expected Output - 

please see attachment (first one is pivot table output and second one is pivot table fields) 

thank you 

kauser 

[OTrieger]

@kauser 
You can use Summarize Tool
Group - Company, Group - Name, Sum - $$

[kauser]

@OTrieger 

yes i did but i wont give me the output we get in excel(plz see my attachments from first post) 

[abacon · Accepted solution]

Alteryx doesn't really output data like a true excel pivot table. However, I was able to recreate your output with the workflow below. Does this accomplish what you are looking for?

[OTrieger]

@kauser 
As you will need one more Summarize Tool, but without of the the use of the grouping by name, then you will have also the total, and you will need to merge the 2 data sets. It will not have the exact same look at in a Pivot nevertheless you will get the same values as you get in the Pivot.

[kauser]

thank you so much for your help. Great work