Grouping and Aggregation Problems

i have table looks this:

ccy	security	pnl
usd	aaa	100
usd	aaa	200
usd	bbb	500
eur	ccc	100
eur	ccc	300
eur	ddd	100

i'm trying create report looks this:

ccy	security	pnl
usd	aaa	300
	bbb	500
	total	800
eur	ccc	400
	ddd	100
	total	500

in order collapse multiple lines security description, i've grouped pnl subtotals security description , have report looks i'm unable create totals ccy:

ccy security pnl usd aaa 300 bbb 500 eur ccc 400 ddd 100

hi milestogobeforeisleep,

from description, have added group grouping ccy, , add child group grouping security. in case, if want add total row calculate sum of pnl each ccy, can refer following screenshot:

report achieve requirement:

if have more questions, please feel free ask.

thanks,
katherine xiong

SQL Server  >  SQL Server Reporting Services, Power View