Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The best way to do this, add calculated dimension. Something like below,
=STATE&Chr(10)&'Total Volume='&Aggr(Sum(VOLUME),STATE)
Try chart properties->Presentation->Show numbers in legend(Check box)
The best way to do this, add calculated dimension. Something like below,
=STATE&Chr(10)&'Total Volume='&Aggr(Sum(VOLUME),STATE)