How to show grand total in trellis chart ?

[#1]

Hi, I am looking for solution to show grand total of legends in each charts shown in trellis

Sample Data:

STATE	CITY	VOLUME
MH	PN	100
MH	MUM	200
KN	BN	900
KN	TN	800

Output:  Please see the attachment, output should have a trellis and Grand Total of legends.

[vardhancse]

Try chart properties->Presentation->Show numbers in legend(Check box)

[Anonymous · Accepted solution]

The best way to do this, add calculated dimension. Something like below,

=STATE&Chr(10)&'Total Volume='&Aggr(Sum(VOLUME),STATE)