Subtotal question. Really simple question. Please help

[jadams123]

Hi I want to be able to total the subtotal amount. How can I do that?

This as you know gives me the Total of the whole column (CY - Territory). 

Sum(Total{$<Brand={'xyz'},[Reporting Group]={'xyz'}>}[# Amount])

Region	Territory	CY - Territory	CY - Territory XYX
Atlantic	XYZ	$1,088,104.54	$46,691,919.06
Atlantic	ABC	$1,130,739.79	$46,691,919.06
Atlantic	Total	$2,218,844.32	$46,691,919.06

I would like to know the subtotal amount. How can I do that?

Region	Territory	CY - Territory	CY - Territory
Atlantic	XYZ	$1,088,104.54	$2,218,844.32
Atlantic	ABC	$1,130,739.79	$2,218,844.32
Atlantic	Total	$2,218,844.32	$4,437,688.65

Thanks, 

J

[jadams123]

Please note. I am only a front end user and I am using pivot table. If this cant be done in a pivot table how to do it in a straight table. 

[sunny_talwar · Accepted solution]

May be this

Sum(TOTAL <Region> {$<Brand = {'xyz'}, [Reporting Group] = {'xyz'}>} [# Amount])

[jadams123 · Accepted solution]

10 Trillion thanks. SOLVED!