How to generate total for each section in a column in pivot table?

[Thanvi]

Hi,

I'm new to Qlik and I'm trying to generate a table as shown below. Using the Pivot table, I came up with getting near the structure but could not add the Total row for Amount as shown for each unique value in Name. How can I add that?

Name	ID Number	Amount
James	1	$                    2,500
	2	$                    5,584
	3	$                    5,755
	Total	$                 13,839
Stephen	6	$                    5,581
	7	$                    5,584
	Total	$                 11,165

[Or]

Toggle the "Show Totals" option for the ID Number field.

[Thanvi]

Thank You Or, I was able to put the new row total, but I'm not sure why the values in total are empty. It is failing to calculate the total. Any help on this?

[Or]

You didn't post your formula, so no idea... odds are the formula is written in a manner which doesn't allow it to be totaled.